Total of Sum (1 Viewer)

[Toyotagrl]

I have a query that counts and sums. It looks like this

Resp Group CountofResp Group SumofcountofResp Group
IA110/210 1 525
IA120/220 1 620

How do I total the sumofcountofResp Group?

Help me please1
Thanks

 

[Cosmos75]

Create a query that includes sumofcountofResp from that query and group by sum.

 

[Toyotagrl]

That only gives me the sum number again...

 

[sxu-mic]

What are you grouping by?

For example:
I. Year Month Date Sum will give you sum per date
II. Year Month Sum will give you sum per month
III. Year Sum will give you sum per year

Resp Group CountofResp Group SumofcountofResp Group
IA110/210 1 525
IA120/220 1 620

I'm not sure I'm interpreting this correctly, but if you're trying to add 525 and 620 you need to get rid of whatever field is generating [IA110/210] and [IA120/220]. So long as this field displays two separate results the sums will not be added.

 

[Toyotagrl]

Adding Resp Groups

 

[sxu-mic]

Toyotagirlsee my edited post above, i added something

 

[Toyotagrl]

I am counting my groups which are named IA120/220 etc. I count, then I sum the count, but then I don't know how to get a total of my sum

I really don't like Access!

 

[simongallop]

Create a copy of the query that is showing the totals by group

In the design grid you will have Resp Group and Sum of RespGroup

Delete all fields EXCEPT SumofRespGroup

Now you should have one field showing one item which is the grand total

HTH