Filling a manual field with incrementing numbers in a query

  • Thread starter Thread starter Volkan
  • Start date Start date
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.
 
| 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.
 
Back
Top