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

This works for me:
http://www.vb123.com/toolshed/07_access/countercolumn.htm

Stephen

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Saturday, 25 May 2013 8:26 a.m.
To: Stephen
Subject: [AccessD] Returning a "Row Number" in a query

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com