Report with multiple sources 1

[cbaten]

I have 2 tables that track donations. The 1st is "Donor Info" which has the name/address information, as well as several yes/no fields for queries. The second is "Donation Items" and contains description & quality fields. The Primary Key in the Donor Info table is linked to a field called "Key" in the Donation items table.

I have a report that lists all the donations from a date range. The main report lists donor info, the subreport lists the items and quality. I have now been asked to change this report, so that if a donor appears more than once in the date range, it lists the donor info ONCE on the main report, but the subreport lists ALL items donated in this date range.

I tried to base the report on a Find Duplicates query, which shows records with matching first & last name, and an assigned donor number. It finds the records, but puts each duplicate donor on a separate page. Plus, since the report is based on this query, it only shows the duplicate donors, and not all donors in the date range.

Access programming is not my strongest suit! Can someone help me set up this report?

- Thanx in advance for your help! "Love, Peace, and Afro-grease!"

Chris

 

[sxschech]

Instead of Find Duplicates query, you could either create a summary query or do a group by on your main report. For a summary query you would click on the Sigma button (like the one used in excel for summing). If using group by on report, then you need to make the Sorting and Grouping window visible and then select the field to group by and choose either header/and or footer. An alternative, depending on your data is to use the Hide Duplicates option of the field properties window for the fields you don't want to display more than once.

 

[cbaten]

Just wanted to add my personal thanks! I was able to use your suggestions which lead me to a solution that gave me exactly the report I needed! I couldn't have done it without your help! Thanx, sxschech!


- Tek-Tips.com is GROOVY!

 

[sxschech]

Glad to have been able to help.