How do I make blank fields in forms count as zero in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a form I am trying to multiplly and add numbers but I do not want the
zeros to show and I want blank spaces to act as zero so that expressions will
show totals if some fields are left blank.
 
Use the Nz() function around each field name in the equation.

Example:
Nz([Field1], 0) + Nz([Field2], 0)

This will replace a Null value with 0.
 

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

#VALUE! when trying to calculate from results of a VLOOKUP 1
Form calculations. 5
Nz not working in a cross tab 1
Displaying zeros in cells 2
Return a Zero with Count Function 10
null returned from zero input ? 7
Convert zero-length string or blank cell to null 3
display zero for blank records on report 5

Back
Top