View Full Version : Calculation in forms (revisited)


Terryb
07-15-2000, 06:22 AM
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
07-15-2000, 07:54 AM
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
07-15-2000, 07:56 AM
ooops!
my email address is musicmaker@aristotle.net

Pat Hartman
07-15-2000, 08:04 AM
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)