Have Label or TextBox countain sum of 2 values in Form

[bugsy]

Hey All

how can I have a Label or TextBox countain sum of 2 values in Form ?
Form is based on a table; I'd rather not change it to a query.

I think I've done it before; but don't recall exactly how.

 

[boblarson]

how can I have a Label or TextBox countain sum of 2 values in Form ?

Set the controlsource to:

=Nz([YourFieldName1Here],0) + Nz([YourFieldName2Here],0)

Form is based on a table; I'd rather not change it to a query.

Not sure why because a query is how it really should be set up. Believe it or not, when you use a table, it is really only a view (query) anyway but it is unordered.

 

[bugsy]

Thanks Bob !
Nz worked great.