Hello..

I am struggling with what should be a fairly simple construct, but for some reason it isn't working. What I am working on is a Donations database. To break it down I have 3 basic tables which contain data as follows...

Table Join Fields Other Fields
Donors DonorID Name1, Name2, Address...
Donations DonationBatchID Total, Payment Method, Date...
Items DonBatchID (same as above) Amount, BudgetDesignation...
Receipt ReceiptID RcptNo, IssueDate, EligibleAmt


My question has to do with setting up a 3 tier report. The receipt itself contains the address, names and total that I want to get from a Sum field.
I want to be able to select a donor account and press a button to issue a year end receipt tax deductible receipt.

The first tier will contain the information on the Receipt. Most of this is found in Donors, other than a few in Donations.
............The second tier will contain general information about each donation in the receipt, followed by a...
.......................Third tier which has another record for each additional itemized gift designation.

So far i used a query to gather all the info together and created the report using a criteria function to get DonationBatchID. Since DonBatchID is the same number, it seems to work, except that it isn't showing the second and third donation covered by the same receipt. It only shows the first. I get the problem. The criteria needs to move up a level. I need to search for the donor, and then all donations related to that donor should show up. But when I used a criteria function to get the DonorID, the report showed blank.

Advice? I am sure you will need more info, but I might need to do that tomorrow.
Thanks

Gary