Record count/identifier

[PAULCALLAGHAN]

I'm using Access 2000 and have created a simple query.

How can I develop a formula that will give me the record count number? The first record is 1, the second record is 2, and so on.

Any suggestions would be greatly appreciated.

 

[Golom]

Do you want the total number of records or do you want a number attached to each record? First one's fairly simple. Second one's much more difficult.

 

[PAULCALLAGHAN]

The second case.

Have the record count number for each record.

 

[PHV]

So, you want a ranking query and for this you need a unique sort key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244