Calculating two or more fields in a Table

P

Programming Cells

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?
 
T

TonyT

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..
 
F

fredg

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