Calculated Field in a Query for a Sequence Number Based on Date

[David Ball]

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

 

[June7]

Very common topic. Start with review of http://allenbrowne.com/ranking.html

 

[isladogs]

Allen Browne's solution involves the use of subqueries.
For another approach using the Serialize function, see Rank Order In Queries