Brad Marks
BradM at blackforestltd.com
Fri May 24 15:45:35 CDT 2013
Stephen, Thanks, I appreciate the assistance. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond Sent: Friday, May 24, 2013 3:26 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://h0stname/cgi-bin/learn-msg.cgi?id=B5E92288C8.96D92