Row counter on a query

[Dbless]

I have two separate queries that gives me gross sales by customer account, one query for current year, and one for last years gross sales. I need to know in what order on both queries account number 12345 is at. For example: current year account number 12345 is ranked 40th, and last year account number was ranked 27th. I want to pass this information onto the report for displaying purposes. Question is how to a get a running total for each line item so that I get "1,2,3,4,...." on each row.

Thanks

 

[stevedi]

Go here,

http://support.microsoft.com/default.aspx?scid=kb;EN-US;207626

and download the example database it's in there.

SteveDi