Nulls in Crosstab queries

[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

 

[Duane Hookom]

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

 

[Dave]

Thank you!!!

It works as advertised!!!!

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

--
Duane Hookom
MS Access MVP
--

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