T
Tina
I have a query that queries 3 tables: customer
information, System Information, and system requirements.
A report is created from this query. Each customer can
have more than one system in more than one location.
My report has the Customer, Location, Manager on the main
report; and a subreport with the system. It groups
similar systems for each customer on the same report.
However, the information is repeated for each location.
So basically I end up with identical copies of information
per each location. How do I get my report to only display
one report per location instead of duplicating all the
information? If I use a code, what would it look like.
The other problem is that some customer's have multiple
locations....How would I sort on the Customer, Manager,
and Location.
I, also, need to group the systems according to manager.
Right now, it lists the first manager from the first
record under the customer. Any suggestions on how I would
do this????
information, System Information, and system requirements.
A report is created from this query. Each customer can
have more than one system in more than one location.
My report has the Customer, Location, Manager on the main
report; and a subreport with the system. It groups
similar systems for each customer on the same report.
However, the information is repeated for each location.
So basically I end up with identical copies of information
per each location. How do I get my report to only display
one report per location instead of duplicating all the
information? If I use a code, what would it look like.
The other problem is that some customer's have multiple
locations....How would I sort on the Customer, Manager,
and Location.
I, also, need to group the systems according to manager.
Right now, it lists the first manager from the first
record under the customer. Any suggestions on how I would
do this????