Form calculations.

J

Jwil

Hello,

I am adding two fields on my form but it only shows the result if a number
is placed in both fields. Is there a way to show the sum if only one field
has a number and the other field is blank? Assuming the blank is a zero and
it would be nice for it to be blank and not show a zero.

Thank You
 
D

Duane Hookom

I'm not sure why you didn't post the expression. Generically try:
=Nz(FieldA,0) + Nz(FieldB,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

Top