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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top