Query Help

[doctor_robert]

How would I write a query that would list by number how many records are in a table I can get it to show the total of all the records but in need them numbered 1,2,3 and so on?

 

[Swamp Thing]

I'm not sure about numbering rows in the query itself... but if you are displaying the query result in a form or report, you can add a bound control that has its data source set to :-
=CurrentRecord
and it will show a serial number for each row displayed.

 

[doctor_robert]

Thanks works great !

 

[CT Witter]

to do this in a query see MS KB article : 94397 - Adding Dynamic Counter to Query to Count Records

http://support.microsoft.com/default.aspx?scid=kb;en-us;94397&Product=acc

HTH,
CT