Adding row count to access query

[ariel20029]

Hi, I am trying to add row count to an access query so each row has a unique number. I tried the Dcount but it was giving me an error message.

Thanks for your help,
Sharon

 

[ranman256]

Access doesnt do 'row numbers'.
Now, you could write the query to a table using make table query.
Then afterwards in design mode, add an autonumber field.
This will number the rows.

 

[ariel20029]

Access doesnt do 'row numbers'.
Now, you could write the query to a table using make table query.
Then afterwards in design mode, add an autonumber field.
This will number the rows.

Ahh thank you, Sharon