Calculations in Reports from Cross Tab Query

  • Thread starter Thread starter Sanjay Sabhlok
  • Start date Start date
S

Sanjay Sabhlok

I have a report, whose control source is a Cross Tab Query
which has three fields Say: X, Y, Z. I have a field in
Report which should show the total of X, Y, Z.

The problem is the total field in Report is summing up the
entire query's X, Y, Z where as I want individual total of
X, Y, Z for each row and not total of X, Y, Z of the
entire row in a query. Please help....
 
What kind of control expression are you using that shows the "entire query's
X, Y, Z"?
If you want a total of each record's X+Y+Z in the detail section, use:
=Nz(X,0)+Nz(Y,0)+Nz(Z,0)
 
Back
Top