How to create a sort order number in a query

W

WarrenG

I need to be able to create a field in a query that sorts a list of ascending
times into a number for different vehicles (V1, V2 and V3), (earliest time =1
for each vehicle), for the same day. eg on date 1, V1 leaves at 10:00, 12:00
and 14:00, V2 leaves at 06:00 and 12:00, V3 leaves at 13:00, 13:30, 14:00 and
14:30. The result I am after would have V1 at 10:00 = 1, 12:00 = 2, 14:00 =
3, V2 06:00 = 1, 12:00 =2, V3 13:00 =1, 13:30 = 2, 14:0 = 3 and 14:30 = 4,
and so on for consecutive dates.
Date, Vehicle ID and leaving time are all in the same table, with one record
for each vehicle leaving time.
Regards
Warren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
How to build query 8
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
15 minute data to daily data 1
Conditional Formatting 0
Merging Qry into Table 2
Add Hours by Looping through Data Q 27

Top