Default to 0 so I can do a calculation

[Keith]

I have a crosstab query that gets its data from a Select
query. I would like the values in the crosstab tab if
blank to default to "0".
The reason for this that the queries feed a report and I
need to add some total numbers and percents data fields
and as it is now some of the values are blank so when I
tell the field to do a calculation if one of the fields is
blank it will not do the calculation.

 

[Jeff Boyce]

Keith

Already answered in another newsgroup. If you feel you must post to more
than one, put all in the To:/Newsgroups: line -- that way, an answer to one
shows up in all.

Jeff Boyce
<Access MVP>