Duplication on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

We have created a report where we are pulling information from 2 separate
tables. When we join our sub report to the main report using master and
child, the report then creates mutiples for e.g.

If there are 4 records for one person on each table the report then give us
16 results. Each person has there own ID which is how we are joining them on
the report. Is there anyway we can just show the 4 results from each table??
without it creating duplicates...

I hope this makes sense, if not please let me know and I will try and
explain further.

Thanks in advance for your help.

Cheers

Paul
 
Paul,
When you link a master to a child, it matches each occurrence in the
child to the master, creating your duplicates. Sounds like you don't really
need a main and sub-report. Can you combine your data from 2 tables and use
the combined data as record source for report? A union query might work for
you, or possibly a new table that appends data from your other 2 tables.
Hope this helps.
 
Your question lacks details regarding the Record Sources of the reports as
well as the link master/child properties. The Main report should not have
any of the detail records from the subreport.
 
Back
Top