Sum of counted values in a query

[johan]

Hello,

My question,....

I have a query which count the number of records in a table (as a
result of the menuoption view-> totals ->count) as a result of the
group by function for unique records.

The result is:
column1 column2
A 10
B 15
C 8

Now I want to insert a column3 which gives the sum of that counted
values. I'd tried something like: expr1:Sum(Count[column2])

The result should be for each record in column3: 33 (result of the
sum 10+15+8)
It doesn't work.

Somebody knows a solution ?

Thanks
regards,
Johan

 

[Arvin Meyer [MVP]]

You can always write another query:

Select Sum([Column2]) As TotalCount From Query1

 

[johan]

Thanks Arvin,

Simple. It works oke.