True zeros in Crosstab

  • Thread starter Thread starter Peter Nunez
  • Start date Start date
P

Peter Nunez

I have a crosstab that works perfectly. The problem is I
would like to have a zero value instead of empty cells
where the counts are supposed to be zero.

How do I display a zero for counts which are zero?
 
It would help if you had shared your SQL. You can change the value to
something like:
theVal:Val(Nz(Sum([yourfield]),0)))
Change the Totals to Expression.
 
Thanks Duane, I used the nz portion and it worked just
fine.

-----Original Message-----
It would help if you had shared your SQL. You can change the value to
something like:
theVal:Val(Nz(Sum([yourfield]),0)))
Change the Totals to Expression.

--
Duane Hookom
MS Access MVP


Peter Nunez said:
I have a crosstab that works perfectly. The problem is I
would like to have a zero value instead of empty cells
where the counts are supposed to be zero.

How do I display a zero for counts which are zero?
Click to expand...


.
Click to expand...
 
Back
Top