I can get a simple count of the records in my report by setting control source=1 and "over all", but I need to do this within a separate field in the query itself.

Any suggestions would be greatly appreciated!

Check Access help for info on DCount.

--Counting Mac

Why do you need the count in the query?

I was unclear in my question. Basically, I'm needing to get a rank of two fields in a report. Setting up one field for this in the report works fine (use control source =1 --it's basically a rank). The other is more difficult. So, I'm assuming I need the query itself to produce the rank so it can be added to the report separately. So is there a way within the query screen to set up a field to "count down" the list of results from the query in the same way that a report will allow you to do if you set the control source=1 and running total to "over all"? I hope that clears it up. Thanks.