Summary of Donations

[Craig Ferrier]

I have a tabe which records donations but I want to create a summary of
donations received by donor (DonorID) and by DonationYear totalling the
AmountReceived.

How do i do this - query/form ?

 

[Allen Browne]

1. Create a new query using the Donations table.

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

3. Drag the DonorID field into the grid.
Accept Group By in the Total row under this field.

4. In the next column, in the Field row, enter:
DonationYear: Year([DonationDate])
and accept Group By.
(Note if you already have a DonationYear field, just use that.)

5. In the next column, choose the Amount field.
In the Total row under this field, choose:
Sum

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.


news:[email protected]...

 

[Tom Ellison]

Dear Craig:

A query to do this probably reads:

SELECT DonorID, DonationYear, SUM(AmountReceived)
FROM YourTable
GROUP BY DonorID, DonationYear
ORDER BY DonorID, DonationYear

Tom Ellison

 

[Craig Ferrier]

Thanks to both Tom and Allen

I knew I was in the right area, but had too many fields in the query.

I got what I needed.

Regards
Craig