take sum of two columns and put in third

[mark]

I have done it in a query. I need to eventually get a table that can be
accessed by an external program and it needs the sum of two entered values.
I'm trying to automate the process. The only way I can access with AutoCAD is
to have the result in a table. I have tried to enter info in one table and
query it and put it in another unrelated table. I get a circular error. We
used to to do this in school. The formula builder would allow us to basically
create the formula in the third column: ONUPDATE(column1 - column2) When
entering info in a form or table I would enter 3 (in column 1) and 1.5 (in
column 2) and result of 1.5 would instantly show up in the result column and
value would be current in the table. Just like a spreadsheet. This was
Several versions ago and I can't figure out how to do it now.

 

[Jeff Boyce]

Mark

If you've already created a query that "does the math", why not connect to
the query instead of the table?

Regards

Jeff Boyce
Microsoft Office/Access MVP