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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: BoffoSteve
- Order by date
-
Criteria required for excluding multiple records in a query
Hmm, it's not clear to me what you're after. Perhaps look up "DISTINCT", "DISTINCTROW", and "GROUP BY" in Help's Answer Wizard for some ideas? Cheers! Steve- BoffoSteve
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
How to compare time in query?
Volcano, et al: I'm curious about those one-minute gaps in the shift times. For sake of simplicity, I'd skip the table and create a function for the purpose (assuming you can take advantage of the Access environment): Public Function strUserGroup(dtmClockTime As Date) As String 'Call with time...- BoffoSteve
- Post #15
- Forum: Microsoft: Access Queries and JET SQL
