Chey,
Use a Totals query. From query design view, select View, Totals. The
screen will change to include a Totals row.
If you simply want the grand total for each currency field, enter each on
the grid and select Sum in the totals row. If you'd like a separate total by
some *other* field, e.g., State or Regional Manager, etc., include these
fields at the left side of the grid, and select Group By in the Totals row.
The query will produce a separate total for each unique combination of the
GroupBy fields in the database.
The resulting SQL will look something like the following, which produces a
single total for all amounts donated in a Donations table:
SELECT Sum(Donations.Amount) AS SumOfAmount
FROM Donations;
Hope that helps.
Sprinks
