Auto calculate field

[RichGags]

I have 4 fields on my form. "MUS-$" "PROP$" "UPGRADE" and "TOTAL"
I have the "total" field control source set to this:
=[MUS-$]+[UPGRADE]+[PROP$]

When I add a new record, it will not total unless all fields have values in them. How do I get the Total field to update regardless of if they have "UPGRADE"s or "PROP$"

Thanks.

 

[Rich]

Look up the Nz function

 

[RV]

Use the NZ function.
BTW, you can search the forum for this kinda question, has been asked before...

RV