Calculating A Field Value

[Malcolm Hegarty]

I want to add a field called Payments to a table. The value of this field is
calculated by multiplying the Days field and the Fee field together (the
Days and Fee fields are both in the same table as the Payments field).

Could any one point me to information on how to set this up?

Thanks,
Malcolm

 

[Jeff Boyce]

Malcolm

Consider an alternative approach. A review of this newsgroup will reveal a
frequent response to requests for "calculated fields" in tables -- DON'T!

If you have the terms and factors needed to derive the calculated value, you
don't need to store it. And storing a calculated value opens a new set of
complications that you rarely need (or want) to deal with.

Instead, create a query on the table. In the query, do your calculation.
Now the calculated value is available to any form, and (other) query, and
any report that needs that calculated value.

Good luck!

Jeff Boyce
<Access MVP>