Report showing counts of two tables

[ThomasK via AccessMonster.com]

I'm trying to create a query for a report that will show total counts of
inspections and reinspections. I have two tables, Inspections and
Reinspections. For every inspection there may be one or more reinspections.
The tables are ofcourse linked one to many. Each inspection has a Inspection
Date field. Each reinspection has a Reinspection Date field. What I want is a
report showing only the total number of Inspections and the total number of
Reinspections.

This seems easy but I can't get it to work.

Thanks

 

[Guest]

Add two text boxes to your report with control sources like:
=DCount("*","Inspections")
=DCount("*","Reinspections")

 

[ThomasK via AccessMonster.com]

Thanks, I'll try it.