row number

B

Baja

how to make a field using expression in a query for row number?
for example:
i have to fields from database order ID and price.
now i want a third field that shows row number for each record starting with
1.
query is sorted by price.

how to do this?
 
D

Dennis

Record number (which is what you want) is dynamic. In Access, there is no
reason to see it, because it can't be reliably used for anything. Reliably
being the operative word. What exactly do you have in mind...?
 
B

Baja

Record number (which is what you want) is dynamic. In Access, there is no
reason to see it, because it can't be reliably used for anything. Reliably
being the operative word. What exactly do you have in mind...?
Click to expand...

yes, i want to see that record number for each record.
 
Top