Sum in a Crosstab query

R

Regi

I created a crosstab query. When I did that I got columns of data that were
created by the crosstab query. They are called 11, 12, 30 and 40 through 49.
I'd like to get a sum of the data in the rows of columns 40 through 49.
However, when I try doing a sum expression I keep getting the data from all
of those columns. How can I just get a sum of the rows of columns I need.
Thanks.
 
K

KARL DEWEY

Open the query in design view. Revise the Totals like this --
Totals xxx xx: Sum(Iif([YourColumnHeadingField] Between 40 and 49,
([YourColumnHeadingField], 0))
 
Top