adding two records together if data is equal

[TonyB]

Hi,



Is there a way in Access to sum two different records together, if the data in two or more fields are equal?
My table has a list of applications ("PrimOrg") and a total amount of money each one has received (Amount) for each application:

...
ID PrimOrg SumofAmount
001 Dashwood Comm. School 5000
002 Dashwood Comm. School 200
...

I want the output to show Dashwood Comm. School to have 5200. I am already summing the Amount column because each application can have multiple amounts entered under it. However, it won't include amounts from a different application. So I sort of want a "Sum of Sums"!

Any help much appreciated, thanks.

[JoeM]

This can be done pretty easily with an Aggregate (Totals) Query.
See: http://office.microsoft.com/en-us/ac...010096310.aspx
and http://www.fontstuff.com/access/acctut04.htm