Calculating two or more fields in a Table

[Guest]

I have a table and within one field I would like to provide the sum of two
seperate fields. Can this be done within the table?

 

[Guest]

It can, but it is very bad practice to do so in a normalized database, no
calculated data should be stored unless the work involved in re-creating the
calculation is more cumbersome than current equipment could be expected to
acheive in a reasonable time.

TonyT..

 

[Guest]

Ok. So it sould probably be done outside the table in a query perhaps?

 

[fredg]

Ok. So it sould probably be done outside the table in a query perhaps?

That's correct. You can use a query:
Total:[FieldA] + [FieldB]
or directly in the control source of an UNBOUND control on a form or
in a report:
=[FieldA] + [FieldB]