I know there is a AutoNumber function in Tables. I was wondering is there a AutoNumber function in a Query, or something that would count each row (EX. Row one value 1, Row two value 2, ...)?
Thanx,
A.
Novice
Windows 7 32bit 
Access 2003
I know there is a AutoNumber function in Tables. I was wondering is there a AutoNumber function in a Query, or something that would count each row (EX. Row one value 1, Row two value 2, ...)?
Thanx,
A.
Competent Performer
Windows Vista Access 2003
if you have selected the autonumber (usually ID) field when you made the query, it will display that data
Creating an autonumber field with a with a Make Table Query
Posting Permissions
Reply With Quote