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
 
Ad

Advertisements

Ad

Advertisements


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