When creating your crosstab query, rather than use the field name for the
field(s) that could have Null values, enter an expression like this for the
field in the query grid:
=IIF(IsNull([MyFieldname]),0,[MyFieldName])
When you press Enter after typing this in, ExprX will appear on the left of
the equal sign. Highlight the ExprX and enter some descriptive name for the
query field.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Sherman H." <sh***@charter.net> wrote in message
news:10*************@corp.supernews.com...
How to set the blank cell to 0 when a crosstab query is created?
Thanks.