Calculating two or more fields in a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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..
 
Ok. So it sould probably be done outside the table in a query perhaps?
Click to expand...

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]
 
Back
Top