Yes I am using Word, and I really don't know if the result is only shown on the screen or saved to the file. How do I get it to save to the file?
Bob CAPITAL AGREEMENTS CORPORATION Tele 888. 583. 0400 Fax 888. 583. 0401 Nationwide Commercial Financing & Leasing since 1989 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of phoogenb Sent: Tuesday, April 10, 2007 12:16 PM To: [email protected] Subject: [ms_access] Re: Field that does not show up 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] <mailto:ms_access%40yahoogroups.com> ps.com, "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? > [Non-text portions of this message have been removed]
