Software

Ask something
Discussion Locked

Access table row numbering

0 helpful
2 replies

by sandymac

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to create a query and to create a column numbered 1,2,3 ...n where n is the number of rows. Is there a function to do this? I normally have to use VB to run down the bast table and put a sequence number on each row, but this seems clumsy!

2 replies

by benwagg

I think rather than Access I would use Excel for this job. It handles sequential numbers quite nicely.

Cell A1 gets the value 0 (zero) and cell A2 gets =A1+1, then copy that formula all the way down column A. Pull down Data > Get External Data > New Database Query, and create a query that points to your Access database. Include Field Names and drop the query results in cell B1, so the first returned record will be numbered '1', the second '2', etc.

This probably qualifies as a "clumsy" solution too, but it should do in a pinch...

by sandymac

Thanks, but I really need to automate the process in an Access Application. Yes, Excel does it just fine so why not an equivalent in Access?

This discussion is closed to new replies.