Nulls in Crosstab queries

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a crosstab query running that has empty fields in the records
results.

Is there a simple way to have a 0 zero displayed instead of a blank filed.

I am counting the crosstab fields.

Thanks in advance
 
This is usually done by wrapping your value expression in something like:
TheValue: Val(Nz(Count([fielda]),0))
 
Thank you!!!

It works as advertised!!!!


Duane Hookom said:
This is usually done by wrapping your value expression in something like:
TheValue: Val(Nz(Count([fielda]),0))

--
Duane Hookom
MS Access MVP
--

Dave said:
I have a crosstab query running that has empty fields in the records
results.

Is there a simple way to have a 0 zero displayed instead of a blank
filed.

I am counting the crosstab fields.

Thanks in advance
Click to expand...
Click to expand...
 
Back
Top