How to create column with a row count ?

robc · Nov 2, 2003

How could you create an expression which would simply server as a row
counter in a query (without using the Autonumber) ?

Van T. Dinh · Nov 2, 2003

See Stephen Lebans' RowNumber:

<http://www.lebans.com/rownumber.htm>

HTH
Van T. Dinh
MVP (Access)

Primary Key AutoNumber Field	1	Mar 13, 2008
Create table query... want to insert autonumber column	3	Aug 22, 2008
Make-table query with around 2 ml records taking too long	0	Oct 4, 2012
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1	0	Dec 11, 2022
Creating queries asking for counts	6	Nov 19, 2009
Row Count...	4	Feb 21, 2012
How do you create an autonumber column in a query?	2	Feb 26, 2010
Help with Query	4	Sep 23, 2008

Ask a Question