Blank fields do not calculate

[Zed5010]

Hi,

I have a form that I would like to only fill in the info at hand and leave the other fields blank. The problem is summing up all the fields returns blank unless I enter zero in the blank field.

Is there a way around this?

Much appreciate it.

 

[TheAceMan1]

Howare ya Zed5010 . . .

Something like:

[blue]   = Sum([purple][b]Nz([/b][/purple]SumFieldName[purple][b])[/b][/purple])[/blue]

See Ya! . . . . . .

 

[Zed5010]

Hi TheACeMan1,
Tired, working on this database for my brother-in-law.

Need your help:

Can you replace the ? with your expression? Thanks

FORM

field1 = 9
field2 = null

Total = ?

 

[Pampers]

Maybe put in the controlsource for the Total-field:

=Nz(field1)+ Nz(field2)

Pampers
There is only one way to change a diaper - fast

 

[Zed5010]

Thanks Pampers!

It's working.

Cheers,

Zed