[AccessD] Returning a "Row Number" in a query

Brad Marks BradM at blackforestltd.com
Fri May 24 15:13:20 CDT 2013


All,

Is there an easy way to return a "row number" in an Access query?

Let's say that I have a table with one field named "Customer".  The
table has 5 rows.

I would like to be able to return something like this...

1 Jones
2 Smith
3 Anderson
4 Olson
5 Jenson 



Thanks,
Brad




More information about the AccessD mailing list