Adding formulas to tables

  • Thread starter Thread starter gjoneshtfc
  • Start date Start date
G

gjoneshtfc

Does anybody know how to insert formulas into tables? I have created a
database for a Car Sales company and on my main form, I entered the
'Profit' data field and then entered the following formula to calculate
the profit: =([Vehicle Sale Price]-[Cost Price]) This works but I want
the value to be entered into the main table as well as on the form and
it isn't. Does anyone know how I can do this please?

Thanks.
 
As posted all the time.

You don't store calculated values in the table. When you need the
calculation, create it in your forms, queries, and reports.

Storing it is redundant and leads to lots of other issues.

For more details, read the hundreds of previous posts on the topic of
"storing calculated" values in a table.
 
Back
Top