Record count in report w/o records
You could make each one a subreport.
You could use a union query to combine the individual queries and add a
field to identify data.
You could combine your queries into a single query with a calculated field
for each result.
If you want some ideas of doing the latter then post the SQL of a couple of
your queries.
--
Build a little, test a little.
"swansonray" wrote:
Hi all,
In the detail section of a report I want to display the number of records a
query returns.
Example query named "support"
In the report I want to display Support = "number of records in query"
and then continue with the number of records in other querys with different
names.
Thank you for your assistance.
Ray Swanson
Lemoore, CA
|