Calculated Fields

[coynesj]

I have a series of tables that cascade down from each other.

I want to insert a calcuted field that multiplies two numbers in the same table and one that is entered at the previous table.

Unfortunately, the calculated function will only let me multiply the two numbers in the same table.

Can anyone help me?

Cheers in advance,

Si

 

[Beetle]

You should not be using calculated fields in a table. Even if you are using A2010, which allows calculated fields at the table level, it's still not good practice. It creates more problems than it solves. Calculated fields belong in queries, or in Form/Report controls, not in tables. If you need to calculate fields from more than one table just join the tables in a query, then create your calculated field.

For more on the subject see this link. Near the bottom of the page you will find discussion about calculated fields in A2010, if that's what you're using.