averaging over multiple controls in a crosstab

[NoodNutt]

Hi guy's

I already have a crosstab working well which breaks down an average based on
a week by week basis.

What I would like to do in the details section is to have a Qtr average
total also.

Now I can get it to =Sum(Nz([W1])+Nz([W2]---->Nz(W13))

But using =Avg(Nz([W1])+Nz([W2]---->Nz(W13))

I get an error

Any thoughts
TIA
Mark.

 

[Allen Browne]

In the query, add the Value field to the design grid again, with Average in
the Total row and Row Heading in the Crosstab row.

 

[NoodNutt]

G'day Allen

Thx for the tip.

I decided to go a different way, which took a lot longer, but it gave me a
better result.

Thx again.

Regards
Mark
Melbourne.