calculating fields in database view

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

Guest

I have a value on field A, another on field B and the result of the sum of these two fields I want to put in field D. Originaly, I am preparing a label (11x13") in Words where I am merging the information above (result from the addition.
 
I have a value on field A, another on field B and the result of the
sum of these two fields I want to put in field D. Originaly, I am
preparing a label (11x13") in Words where I am merging the
information above (result from the addition.
Click to expand...

You ought not, should not, need not do what you are requesting.

As long as your table has FieldA and FieldB, any time you need the
result of a calculation, calculate it.

In your specific merge to Word, make a query.
In the quey, along with what ever other fields are needed, add a new
column:

CalcResult:[FieldA] + [FieldB]

Use this query, with it's [CalcResult] field, in the merge.
 
Back
Top