Duplicate information on my report

[Billie]

Here is my problem. I have 3 tables that all are joined by a project name. THe information on the 3 tables is a developer, the project, and the address (Table 1), the invoices that are assigned to each project (Table 2), and any payments the developer has paid against the projects expenses (Table 3). When I run the report off of all 3 tables, I get duplicated information. For instance, if the developer has made 2 payments for a particular project, all of the invoices that pertain to that particular project are duplicated. If there are 3 payments, then the invoices are triplicated. I know that I should be able to put all of the information on 1 report, I just don't know how to go about it. Any Suggestions???

 

[Majid Umar]

Hi,

In Query Design, Add the Total Field Option i.e. Sigma from Toolbar and than Choose "GROUP BY" apply that on all the fields this should sort your duplicate probelm if there are still some records which are appearing twice than on payment date field or the link feild for Payment to project field choose First instead of Group this should solve your problem!

Cheers


[This message has been edited by Majid Umar (edited 01-28-2002).]

 

[Pat Hartman]

The suggested Group By method will only work for you as long as you are not doing any calculations. If you are adding the payment amounts for example, they will be inflated by a multiple of the number of invoices.

You need to break the report into a main report with nested sub reports -

Main Report - Project
Sub Report - Invoices
Sub Report on Sub Report - Payments