Hi again, It depends. Are you doing the merge in word? Are you basing it on a table (I guess so)? Is field C calculated on the form or in a query (I guess on the form)? Is the result of the calculation stored in the table or just displayed on the screen (I guess not stored)?
If my guesses are correct then you should create a query that calculates field c dynamically, and then base your mail merge on that query rather than on the table. Peter Hoogenboom --- In [email protected], "CapitalLease" <[EMAIL PROTECTED]> wrote: > > I have a record in which I take Field "A" and subtact Field "B" and > that creates the answer in Field "C". That works fine in the > record/form, but when I then do a mail merge with a form letter the > Field "C" sum does not show up in the letter, it reflects a blank. How > can I get the result of function to show up in a merge mail form? >
