MS Access 2007 - 2010, How do I sort by one field, but keep like groups intact?
Posted on 2010-11-11
I might have to write code to do what I want, but I wanted to throw this out just in case. I have some truck scheduling data that I would like to sort by the time field. This data is for each day of the week so truck A might be scheduled to arrive at 0200 on Monday but be scheduled to arrive at 0205 the rest of the week.
This truck should show as:
Truck A 0200 Kansas City M
0205 Kansas City Tu W Th F
Well, I can do this by sorting by the truck name field and then hiding duplicates on that column. The problem is that whole section of data is not sorted by date/time. I want the data to show what is coming in first in the morning to what is coming in last, but keep truck names together.
Is this possible? I thought I could sort the query bound to the report and then do grouping on the report, but the group does sorting...