how to create item numbers column in a Query

M

mezzanine1974

Is there anyway to place a column (Item#) in a query, which will show
the item numbers of the results. Say that, if query result has 13
items, Item# values will be sequentially 1,2,3...11,12,13.
I have a feeling that it might be solved by usind DCOUNT function.
Thanks
 

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

how to create item numbers column in a Query Options 8
how can I get item numbers column for a query result? 5
Query looking up item numbers in a table running slooooooooow 1
How to Copy a Calendar Item to a Future Date? 1
Printing SQL query results in a list of columns, instead of one long column 1
Can I make a table of entries and run a query off of it? 1
Formula to choose from the last column of a given row 2
Is there a better way to run a parameter query on a form? 0

Top