Calculation in forms (revisited)

[Terryb]

Example Table is:
fld 1
fld 2
fld 3
I want to enter fld 1 and fld 2 and have the sum entered into fld 3 in the table.
I tried the solution from DML & not able to make it work.
Can you help further?

 

[musicmaker]

Dear TERRYB and DML

I am having the same problem. I could not get what DML suggested on July 14,2000 posting, to work either. I have researched this whole website trying to find the correct way to do this. No luck so far.

If anyone can help resolve this, please let me know how!!!! Thank you in advance,

my email address is: musicmaster@aristotle.net

 

[musicmaker]

ooops!
my email address is musicmaker@aristotle.net

 

[Pat Hartman]

It is not necessary to store the calculated field in the table. You should calculate it on the fly in a query or in an unbound control on a form.

Select fld1, fld2, Nz(fld1,0) + Nz(fld2,0) AS fld3
From YourTable;

or on a form as the controlsource for an unbound control:
= Nz(fld1,0) + Nz(fld2,0)