[AccessD] Record number in query

Chris Foote (Spike) spikee at oatlandspark.org.uk
Thu May 25 02:29:57 CDT 2006


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





More information about the AccessD mailing list