Transfer SQL to a report

[coach.32]

Is it possible to place the SQL I have for a query into a report? I have a query that counts the number of records within my table. The total is then needed to be placed in a report. There are quite a number of tese queries. So the end result is that a reoport will show the totals of each criteria. I hope I have explained well enough. Any assistance would be greatly appreciated.

 

[pbaldy]

Presuming the values can't be gathered by one query, your two basic options are getting the value with a DLookup() or basing a subreport on the query.