calculating result in tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hellow

I have a table were there are two fields ( FORIGN CURRENCY AMOUNT , AND RATE
OF EXCHANGE ) AND A THIRD COLUMN TO PUT THE RESULT ( fc amount *roe)

IS THERE A CODE OR EXPRESSION TO DO THIS IN A TABLE

thank you,,
 
mhmaid said:
hellow

I have a table were there are two fields ( FORIGN CURRENCY AMOUNT ,
AND RATE OF EXCHANGE ) AND A THIRD COLUMN TO PUT THE RESULT ( fc
amount *roe)

IS THERE A CODE OR EXPRESSION TO DO THIS IN A TABLE

thank you,,
Click to expand...

No. Such calculations are not stored in database tables. Delete that field from
the table and build a query based on the table and do the calculation in the
query. Then just use the query in any situation where you need that value.
 
As Rick points out, Access/JET doesn't have a way to do this from within the
table (and to keep the corresponding related columns synchronized). If you
are using SQL-Server or other back-end data repositories, take a look at
using "triggers" and calculated columns to do this.

Regards

Jeff Boyce
<Access MVP>
 
Back
Top