Adding the value of Crosstab fields together to further summarize data

[priusman]

Hi there,

I have this crosstab query, for which I am trying to further group the data. Ex. I would like to add the values of the three fields circled in red under a single group field called "Boating".


I thought creating a simple query based on the crosstab in which I would add a calculated field would work. Sounded simple enough.



Unfortunately my new calculated field does not return anything.

I have several groups of fields like that in my crosstab that I would like to group together.

Can someone help?

[June7]

Arithmetic with Null returns Null. Have to deal with the Null. Can use Nz() function. Nz([field1],0) + Nz([field2],0) + Nz([field3],0)

[priusman]

Thanks June7 that worked perfectly! Good lesson.

Hi there,

I have this crosstab query, for which I am trying to further group the data. Ex. I would like to add the values of the three fields circled in red under a single group field called "Boating".


I thought creating a simple query based on the crosstab in which I would add a calculated field would work. Sounded simple enough.



Unfortunately my new calculated field does not return anything.

I have several groups of fields like that in my crosstab that I would like to group together.

Can someone help?

[CJ_London]

have you tried having a row heading column in your crosstab query - something like

BoatingTotal:sum(iif([activity] like "Boating*",1,0))