Ocean- what you need to do is to turn on grouping in your query. To do this, open the query in design view and click on the Sigma - the greek letter E. If you hover your mouse over it, the tooltip reads "Totals".
When you click on this, a new row will appear the query grid which reads Total. The default for the Totals row is Group By which means that the selected field will be grouped together (i.e. all donations from Contact 123 will be grouped together.)
You will need to do a couple of things. I am assuming (from your comment) that you simply want to know the number of donations and the total amount of donations for 1998.
When you create a totals query, you only want to include the fields that need to be grouped, totalled or used in a criteria expression.
So, in your example, you want the total number of donations and total amount donated for 1998. So, you need the year and donation amount. Since you want to do two calculations on the donation amount (total and count), you will need to include the donation amount two times in your grid.
Now, turn on the totals row. Make sure the criteria for the year is still there (the one you created earlier). Now, in the totals row, change the year field to Where. This tells Access to include only the data for the criteria you specified but not to show the field in the output. For the first Amount field, change the totals row to Sum. For the second Amount field, change the totals row to Count.
This should give you what you are looking for. Let me know if you have any problems.
Jay
