Preventing dupes in a report

[sawilliams]

I am reporting out people who attend an event. The subreport reports the guests of the people in the main report. The main report works fine. So does the subreport. But if Joe Blow has 5 guests, he and all his guests get reported out 5 times.

My tables are tblEventAttendance which has the invitees and an EventAttendanceID. The other table is tblGuests where the guests are linked via the EventAttendanceID.

This all works just dandy on the forms I've created but I can't get it to work on the report.

 

[THWatson]

sawilliams
Sounds as if you are getting a Cartesian product.

Base your report on a query, and check the results. You may have to change the Join so that All events are shown but only the guests that match the events. Alternatively, change the query a Totals query.

Tom

 

[dhookom]

Make sure that tblGuests is not in the main report's record source query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]