Expression in Table

[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.

 

[Guest]

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