Duplicate Reports

[bsdixon]

I was wondering if someone could help me eliminate duplicate reports.

I have a report with a subreport.

The main report has customer number and their address and phone numbers.

The subform is related to the main form by the customer number. In the subform it then has their order number along with order info.

I am currently getting a report for each order. I do not need this because all of the orders are listed each time. I want the report to just print once per customer number.

How can I do this? Do I need to change my query?

Thanks for your help.

 

[GumbyD]

Just a quick clairification - on the query that runs behind the main report you are only getting on record for each customer? If that is the case then you need to check your grouping levels and the link master / link child setup. If you are getting more then one record for each customer on the main report query you need to change it so you only get one record per customer.

Good Luck.

GumbyD