Auto number in a query (having trouble with dcount)

[BarnetBoy]

I have a query that pulls records from a table based on the value of one of the fields. I would like to put these records in order based on a date field. I would then like to have each record assigned a a whole number (ie "1" for the record with the earliest date, "2" for the ext one...etc. I have tried to use DCount, but I keep getting either the same number returned for every record or errors.

I am a newbie under a bit of time pressure. Any help would be appreciated.

Thanks

 

[llkhoutx]

Build a function which generates a counter and use that in a query column. Of course, you have to initialize the counter, an optional argumnet can be used to inditate that the counter sould be reset to zero.