averaging over multiple controls in a crosstab

  • Thread starter Thread starter NoodNutt
  • Start date Start date
N

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