need no duplicate records in report

[db2]

I'm fairly new to access but am generally computer savvy.

I have an access table of donations that is related by customer id to a table of donator information (company, address, etc).

I have created a query based on the donations table that singles out donators of a specific type, using criteria and the "or" option.

What I need to do is create a report from this donations table that includes the donator information and address for each donator giving in this category, but that does not repeat their information for each donation given.

Any and all help is appreciated!

Thank you for reading.

 

[boblarson]

Set a grouping of donor with a header and put the contact info in the header then you can have the details in the details section.

 

[RuralGuy]

You might also incorporate the "Hide Duplicates" property of a report control that is on the Format tab of the control's property sheet.

 

[db2]

Even if I group by say last name of donor, and incorporate the hide duplicates option in the control formatting I still get blank spacing where the duplicate entries would exist.

Is there something more I'm missing? Is there perhaps an easier way to essentially say, I want a list of all donators who have donated to donation types 1-7, without a duplicate entry if the donator has donated to these categories more than once?

There are three related tables. Donators (id, name, address), donations (id, date, type), and donation types (types (1-12)). The Donators table is related to the donations table via id, and the donation type table is related to donations via 'type'.

 

[Tekture]

Could you set up a query for these three tables? pull the info you want, then enter in the criteria for groups 1-7 only.

Then use that query to build the report.