Sum in a Crosstab query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Regi - 28 Sep 2005 13:20 GMT

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.

Reply to this Message

KARL DEWEY - 28 Sep 2005 15:46 GMT

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

> 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.

Reply to this Message