Field with running count of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
Dcount returning no results!!! 0
counting Null fields 3
query that brings a autonumber field 6
Append Queries 5
Access Dcount (multiple criteria) 3
Need Query to select records based off a Quantity column. 6
Append query with addtional fields 10

Back
Top