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>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IFF in Query?? 3
Crosstab Query Calculation 7
Nz - need code - 2
Make-table query with around 2 ml records taking too long 0
update crosstab 1
Overflow error on calculate field in query - Help Please 1
Calculate in a Crosstab? 4
Aggregate calculations on calculated query fields? 6

Back
Top