Summary of Donations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Ferrier - 23 Mar 2006 02:48 GMT

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 ?

Reply to this Message

Allen Browne - 23 Mar 2006 03:13 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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?

Reply to this Message

Tom Ellison - 23 Mar 2006 03:22 GMT

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

>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 ?

Reply to this Message

Craig Ferrier - 23 Mar 2006 04:19 GMT

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

Reply to this Message