query calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cross tab query that I am using to produce a
report and do some calculations. The calculations do not
seem to be working. My query results are...
Jan Feb my results should be Jan Feb Tot
year1 1 2 year1 1 2 3
year2 2 year2 2 2
year3 4 year3 4 4

But, this is what I get
Jan Feb Tot
year1 1 2 3
year2 2
year3 4

Help please...
 
It looks as if you are running into the fact that one null in a calculation
means the result is NULL. You will need to use the NZ function (Null to Zero)
in either your query or your code in the report.

In the report something like
Nz(Jan,0) + Nz(Feb,0)


In the Query, something like
Val(Nz(YourCalculationField,0))
 
Back
Top