MS Access Record Number 1

[JohnH9]

I need to include each Access record's record number (which is assigned by Access, not by me) in a report which is generated off of a query.

How can I extract the record number for each record?

Thanks.

 

[jbenson001]

You want to post in one of the many Access forums here. This forum is form Microsoft SQL Server

 

[JoeAtWork]

There's no such thing as a "record number", only fields. If you do not have an ORDER BY clause in your SELECT statement, the order of the records is unpredictable.

 

[JohnH9]

Thanks, Joe.