G Guest Mar 30, 2004 #1 Does anyone know how I can create a new field in a query containing the record or row number for each record in that same query? This can be easily done with a make-table query, but I need to avoid that.
Does anyone know how I can create a new field in a query containing the record or row number for each record in that same query? This can be easily done with a make-table query, but I need to avoid that.
C Cheryl Fischer Mar 30, 2004 #2 Here is a link to MVP Stephen Lebans' solution to this issue: http://www.lebans.com/rownumber.htm -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX nc said: Does anyone know how I can create a new field in a query containing the Click to expand... record or row number for each record in that same query? This can be easily done with a make-table query, but I need to avoid that.
Here is a link to MVP Stephen Lebans' solution to this issue: http://www.lebans.com/rownumber.htm -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX nc said: Does anyone know how I can create a new field in a query containing the Click to expand... record or row number for each record in that same query? This can be easily done with a make-table query, but I need to avoid that.
