How to set a null value to '0'

  • Thread starter Thread starter cb
  • Start date Start date
C

cb

I am creating an order entry form. I want to set the the sub-total field for
rows with no data in them to zero. Thanks in advance.
 
cb said:
I am creating an order entry form. I want to set the the sub-total field
for rows with no data in them to zero. Thanks in advance.
Click to expand...

If you have several numeric fields, use Nz() around each one. For example:
=Nz([Parts], 0) + Nz([Labor], 0) + Nz([Tax], 0)
 
I am creating an order entry form. I want to set the the sub-total field for
rows with no data in them to zero. Thanks in advance.
Click to expand...

A couple of ways; probably the simplest is to use a Format property for the
textbox of

#;-#;0;0

to display the number (with or without a minus sign respectively) for positive
and negative values, and display 0 for zero or NULL values.
 

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

If query/subform is empty set calculation value to 0 4
Do I need to solve this with VBA record set? 11
How 2 avoid sub-reports? 2
Crosstab Null value display as a "0" 2
Append Query 2 4
Adding a IF Statement within a Select Query. 2
Subform Data Entry Setting 0
Null Value Error 1

Back
Top