[AccessD] Record number in query

Chris,

I sent you a sample db offline that shows what you need.  Its a simple 2 
line function...but you have to reset it each time you use it.  Also, this 
works best with MAKE,APPEND,UPDATE type queries...if you display a query 
using this function...the numbers will change as you scroll.

Let me know if you don't get the offline sample.

Thanks,

Mark A. Matte


>From: "Chris Foote (Spike)" <spikee at oatlandspark.org.uk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: [AccessD] Record number in query
>Date: Thu, 25 May 2006 08:29:57 +0100
>
>Good day!
>
>Dumb question here.
>
>I've got a SELECT query and wish to add a calculated field with row number.
>The number needs to start at 1, for the first record, and increment to n 
>for
>record n. I'm sure I've seen a post here recently about this but I cannot
>find it in the archives.
>
>TIA!
>Chris Foote
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com