SUM of a SUM field 1

[MikeT]

I have a query pulling the sum of certain fields, and now I need to get the sum of that field:

SELECT SUM([field1]) AS ttlAmount
FROM

ORDER BY SUM([field1]) DESC;

I need the total Amount and the Grand total amount.

Any ideas?

 

[Cagliostro]

give a sample what do you want to get. John Fill

 

[ghubbell]

Don't you ever call me that in public again!
Yes sir. Another query built off of your first. go for the sum of the sum fields. Quick and easy! Gord
ghubbell@total.net

 

[kjonnnnn]

Here's what I used in my church database to sum the sum of Tithe Offerings...

=Sum([Sum Of Tithe])

 

[Cagliostro]

I want just an example, not a definition. John Fill

 

[MikeT]

What do you mean by example???
I thought what I included in the first post *was* an example.
Thanks for your time!

 

[Cagliostro]

Ok, as I understand, you want the first query
select sum(*) as x from xxx group by yyy
this will select differemnt sum for each yyy from table xxx.
select sum(*) from xxx will select the sum of all elements.
If you want a subquery, I don't know exactly how is it in access but in SQLServer you can do

select sum(t.x)
from
(select sum(*) as x from xxx group by yyy) as t
John Fill