How do I insert an autonumeric field in a query (not in a table)?

Question

I need to create a calculate field in a query that reflects the record number in the query (example: value =3 for third record), something like the Row function in Excel.

Answer 1

Declare a variable as a counter. For each record you pull from the table counter = counter + 1.