T
ThomasK via AccessMonster.com
I am trying to create a report showing total counts from two related tables.
I have two tables, Inspections and Reinspections. Inspections has as it's
fields, InspectionID (PrimaryKey), InspectionType, Inspector, InspectionDate.
Reinspections has ReinspectionID (PrimaryKey), InspectionID (ForeignKey),
ReinspectionDate. They are linked one to many, one inspection to many
reinspections. Each inspection may be one of several type, but each
inspection regaurdless of type may have several reinspections. There is only
one type of reinspection.
What I want is a report showing the total count of inspections by type, and
the total count of reinspections. These would be over a certain time period,
(Between_And_). I dont want any other data on the report, and I don't want to
show them by InspectionID. Showing them by InspectionID would separate them
on the page and not give me just the grand total by type.
Can I do this with one query?
Should I use two queries and get the totals first?
Can I do this without listing them by InspectionID?
Thanks,
I have two tables, Inspections and Reinspections. Inspections has as it's
fields, InspectionID (PrimaryKey), InspectionType, Inspector, InspectionDate.
Reinspections has ReinspectionID (PrimaryKey), InspectionID (ForeignKey),
ReinspectionDate. They are linked one to many, one inspection to many
reinspections. Each inspection may be one of several type, but each
inspection regaurdless of type may have several reinspections. There is only
one type of reinspection.
What I want is a report showing the total count of inspections by type, and
the total count of reinspections. These would be over a certain time period,
(Between_And_). I dont want any other data on the report, and I don't want to
show them by InspectionID. Showing them by InspectionID would separate them
on the page and not give me just the grand total by type.
Can I do this with one query?
Should I use two queries and get the totals first?
Can I do this without listing them by InspectionID?
Thanks,