SUM OF TWO COLUMNS PUT IN THIRD

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Worked in older versions. Formula builder would allow us to creat formula in
result column: OnUpdate(column1 - column2) This would put the difference in
the result column and it was in the same table and it was a current and
accessable column of data. I need to automate this and use it externally from
autoCAD. I must have the info in a table. I tried using a second table and
pulling the difference from a query. If the tables are linked in any way I
get a circular ref. error. Circumstances are that I need the this info in a
record IE. the difference needs to stay linked to an ID coulmn in the
table/record.
 
I can get my answer in a query but I can't get that number back into the
table or another table that is linked to original. I get a circular reference
error.
 
Mark,
The question now is why must the result be in a table. It is considered poor
database design to put a calculated number in a table. The obvious reason is
that one of the two numbers can be changed and the result will not change
(2+2=5) You store the two numbers in a table and calculate the result in the
query.

If you are adament, perhaps you could change the query from a select query
to a make table query, generate the result there, then have the query push
all that into a new table. To do this, get your query established and in
Design View, click on the menu item Query, and select Make Table query. It
will prompt you for the name of the new table. However, I would really like
to hear why you think you need the results in a table, because whatever you
plan on doing with the table, you can also do with a query.
 
Back
Top