Record count in report w/o records
If the "number of records a query returns" refers to the report's record
source then a simple text box with a control source of:
="Number of records in this report: " & Count(*)
will work.
If the report returns no records then there will be no Detail Section. You
would need a text box in the Report Header like:
="Number of records in this report: " & IIf(HasData,Count(*) ,0)
--
Duane Hookom
Microsoft Access MVP
"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
|