Default to 0 so I can do a calculation

  • Thread starter Thread starter Keith
  • Start date Start date
K

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.
 
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>
 
Back
Top