Calculations in tables

[Tenebrae]

Hi I'm designing a database for my A Level project and I
was wondering whether there is anyway to include a
calculation in a tabe. I have one field for postage, one
field for the value of the item being posted and I was
hoping to have one field for total value [postage]+[value].
Anyway of doing that?

Thanks,
Tenebrae

 

[Kevin Sprinkel]

While this is possible, it's not necessary, and
undesirable because it's redundant. Simply calculate the
total in a query or report or on a form as you need it.

For example, create a form based on your table and add an
unbound text box to it. Then set its Control Source
property to =[postage]+[value]. It will now automatically
update whenever either of the two fields change.

The same can be done for a report control.

 

[Rick Brandt]

Hi I'm designing a database for my A Level project and I
was wondering whether there is anyway to include a
calculation in a tabe. I have one field for postage, one
field for the value of the item being posted and I was
hoping to have one field for total value [postage]+[value].
Anyway of doing that?

Thanks,
Tenebrae

That would be properly done with a query, not a table.

 

[Tenebrae]

Thanks both of you