Field with running count of records

C

ChuckW

Hi,

I have a query with fields such as date, Item Number and Quantity. I want
to create an additional field called Count that will act like an autonumber.
It will assign a value of 1 for the first record, 2 for the second number
etc. Can someone tell me how to do this?

Thanks,
 
D

Duane Hookom

There are tons of posts on how to create a "ranking" query. You must have a
field or fields that uniquely identify the sort order. If you provided
significant table and field names as well as your desired sort order, someone
could create the SQL for you if you can't search for and find a solution.
 
Top