Filling a manual field with incrementing numbers in a query

V

Volkan

Hi,

I have a manually created field in a query and would like
to fill it up with incrementing numbers starting from 1 to
how ever many records the query returns. Basically the
manual filed should give the number of the record in the
query result. If the query returns 15 records, the manual
filed should start from 1 and end at 15 incrementing by 1.
How do I achieve this in a query? Thank you in advance.
 
E

Eric Cardenas

| I have a manually created field in a query and would like
| to fill it up with incrementing numbers starting from 1 to
| how ever many records the query returns. Basically the
| manual filed should give the number of the record in the
| query result. If the query returns 15 records, the manual
| filed should start from 1 and end at 15 incrementing by 1.
| How do I achieve this in a query? Thank you in advance.
 

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

Autonumber field in Excel that behaves the same as Access 0
Adding data to MS Access from csv file 0
Numeric increment 4
Running Count By Week 6
Need VBA Macro to Loop through pages and print counter in footer of each page 9
DMAX with Criteria 1
How to count the numbers in a Word document? 0
Increment a number based on instances in another table 1

Top