Sum in a Crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Open the query in design view. Revise the Totals like this --
Totals xxx xx: Sum(Iif([YourColumnHeadingField] Between 40 and 49,
([YourColumnHeadingField], 0))
 
Back
Top