Returning record #'s in query-MSAccess - TechRepublic
General discussion
December 20, 2001 at 08:50 AM
jabend

Returning record #’s in query-MSAccess

by jabend . Updated 24 years, 5 months ago

I need to get a query to include the record number / row number for each line returned in a query.

Example:

Num First Last
———————–
1 John Doe
2 Jane Smith
3 Sam Stone

The numbers in the column ‘Num’ need to be part of the results of the query.

-JON ABEND

This discussion is locked

All Comments