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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
only the most recent record...
I cannot find anything similar in FAQs or existing threads... please point me in the right direction if I am asking a duplicate question! I have 2 tables. One lists truck numbers (Trucks), the other has multiple entries for each truck (Truck Activity). I need to print a report showing each...- Niko7
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Dateadd format question
In a query I have a date column "Time Out Door"... I need to sort in the report from 7:30 AM to 7:30 AM (spans across 2 days, but we consider it one day of 3 shifts). The following will sort from 7AM to 7AM, but I do not know how to change the format to 7:30. I have tried 7.5 and...- Niko7
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
