Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculating consecutive years in FT or PT status
I adjusted to show the code properly Option Compare Database Option Explicit Private Sub CalculateService() Dim rsA As DAO.Recordset Dim rsS As DAO.Recordset Dim lngEmp As Long Dim strBeg As String Dim strType As String Dim intCount As Integer Set rsA = CurrentDb.OpenRecordset("SELECT *...- jesmiles
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Calculating consecutive years in FT or PT status
Hi Colleen, I'm still a little confused about your tables you listed above, but it looks like the "Appointment" table is the most relevant, since it lists the Begin Date and employment status. Not sure how you need to be able to show this, but I would suggest creating a new table with...- jesmiles
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Errors Importing Extended ASCII into Access 2007
I initially came here having found the following thread: thread701-1554516 This person was experiencing the same problem I am: Access 2007 does not appear to support importing/exporting text files using extended ASCII characters as delimiters. I am also trying to import Concordance DAT files...- jesmiles
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
