Calculated Field in a Query for a Sequence Number Based on Date (1 Viewer)

David Ball

Registered User.
Local time
Today, 18:16
Joined
Aug 9, 2010
Messages
230
Hi,

I have a field of delivery dates, DelDate, and want to include a field that shows the sequence of the deliveries. I would call the new field Seq.
For example, the earliest date would have a field value of 1, the next earliest would be 2, etc. If multiple records have the same delivery date they would have the same sequence number. If a record does not have a date in the DelDate field the Seq field would be blank.
What formula would I need to put in the expression in the query to achieve this?
Thanks very much

Dave
 

isladogs

MVP / VIP
Local time
Today, 07:46
Joined
Jan 14, 2017
Messages
18,186
Allen Browne's solution involves the use of subqueries.
For another approach using the Serialize function, see Rank Order In Queries
 

Users who are viewing this thread

Top Bottom