Problems with my reports.....

T

Tina

I'm using a report/subreport format to schedule systems.
The main report has Customer ID, Location, Manager, Week,
Service, type of system, and tests for systems. The
Subreport has the System,type of system, location,
manager, week, service. The reports are linked by the
Customer Id, Location, Manager, Type of System, Week.
This all works great....The information for these reports
comes from 2 queries.

However, I have a couple of customers that have the same
manager but different locations that are not displaying
correctly. A report is displayed for each Customer at
each location for each type of system regardless if that
type of system is at that location. When there is not a
system of that type at the specified location, it prints a
report with all the info on the main report, but no info
on the subreport. How do I get these reports not to be
displayed????

When I checked the query, it is creating records for every
type of system whether there is a system at the specified
location. All I can figure is that since they have the
same Customer and Manager, all type of systems within the
customer are displayed for each location whether or not
they exist at the specified location.....Any suggestions
on how to fix this????
 
Top