Report showing counts of two tables

  • Thread starter ThomasK via AccessMonster.com
  • Start date
T

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top