Expression in Table

  • Thread starter Thread starter Emile
  • Start date Start date
E

Emile

I am designing a table with the following fields: Units, Price and Worth.

Worth = Units*Price

When stting up the table can Worth have a Default Value of =Units*Price?

Tried that and I am getting an error message.

Do I have to create a query and do the calculation there.?

Thanks in advance for your help.
 
Hi,
yes...as a general rule you do NOT want to store calculated values in
tables. Instead they can be calculated at runtime as needed in queries or on
forms/reports.
HTH
Good luck
 
Back
Top