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

Top