Question Interpreting blanks as zeros?

laxster

Registered User.
Local time
Today, 09:40
Joined
Aug 25, 2009
Messages
145
I was wondering if it's possible to interpret blanks as zeros?

I have many fields which then use expressions to tally them up. I need to use the val of some text fields. There are also number fields which are multiplied by the val in the text fields.

I find that if I don't place a default value to 0 that I get criteria mis-match errors. However, the final output goes to a report, and the report looks unbecoming with the 0s that keep showing up.

Does Access have a way of interpreting the blanks as zeros?
 
By blank, do you mean Null? Would the Nz() function solve your problem?
 
I would probably use the Nz() function as well, but I'll throw out the option of hiding zeros on the report. The format property of a textbox containing a numeric field can have 4 parts, one of which is for zero values. You can hide them with that.
 

Users who are viewing this thread

Back
Top Bottom