row number

  • Thread starter Thread starter Baja
  • Start date Start date
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?
 
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...?
 
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.
 
You must log in or register to reply here.

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

Access Dcount (multiple criteria) 3
How to subtract a number from a Mergefield? 0
Query Row number don't wotk with duplicate name 3
Auto number records when a form opens 5
Access Query Table: Show value of previous row 1
Lookup field returns wrong value 6
Problem with multiplying value of two fields from different tables 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top