Bob, Where is the calculation performed?
Peter --- In [email protected], "Bob Runyon" <[EMAIL PROTECTED]> wrote: > > 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" <Capitallease@> > 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] >
