Query Counter

[Noah114]

I have a query that is is grouping information but I wish to add a counter to count the number of rows in the out put, how do I do that?

For Example:

Row Car Sales
1 Ford 22,456
2 Acura 45,895

 

[PHV]

Do a search in this forum for rank or ranking

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886