criteria based dsum command

[Guest]

i have a database that tracks memorial donations. it has 2 tables, one
called memorial ID, which tracks the names of the memorials and the families
involved, and one called donations which tracks donations to memorials
contained in memorial ID.

what i need to do is be able to print a report to the family of a memorial
summing the total donation amount to their loved ones memorial. for example
memorial name Homer J Simpson has had 5 people donate to his memorial
totalling 5000 dollars but they are 5 seperate entries inside of the
Donations table.

what i have got to work so far is i have made a totals query grouped by
memorial name and that got me the proper sum but then i cannot put in all the
family information from the memorial ID table.

what i think i need to do is create a DSUM command that has a criteria that
gets entered on the running of the report. I however do not know how to do
this. Ideally, i want to make a form that opens on the running of a report
named Memorial Page 1 containting a list box with all the memorial names.
the user will select the memorial that they want a family total for and the
report will be created.

I appreciate any help. Thank You.

 

[Allen Browne]

1. Create a query that contains both tables.

2. Depress the Total button on the toolbar (upper sigma icon.)
Access adds a Total row to the grid.

3. Drag the fields from the main memorial table into the grid.
Accept Group By in the Total row under these fields.

4. Drag the Amount field from the related table into the grid.
In the Total row under this field, choose Sum.