Table C in Datasheet view has all the data present in it. What should I do now that it is populated?
CAPITAL AGREEMENTS CORPORATION Tele 888. 583. 0400 Fax 888. 583. 0401 Nationwide Commercial Financing & Leasing since 1989 -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of phoogenb Sent: Tuesday, April 10, 2007 3:23 PM To: ms_access@yahoogroups.com Subject: [ms_access] Re: Field that does not show up Bob, 1: Am I correct in guessing that it's something like this: you have a textbox called "FieldC". The controlsource of that textbox is =[FieldA]+[FieldB] Is that right? 2: I guess that the data source for your word mailmerge is the table you created. Is that right? 3: If both of these things are right, then do this: A: Open the table in datasheet view. You should confirm that FieldC, if present, has no data in it. B: Switch to design view. Delete FieldC from the table. Save your changes. C: Create a new query. Add your table to the query design grid. D: In the first grid column, select [TableName].* (this will include all the fields of the table) E: In the second column, in the "Field" box, type this (obviously, use the actual names of your fields. The square brackets are only necessary if your field names contain spaces or certain other characters): [FieldC]: [FieldA] + [FieldB] F: Save the query and remember its name. G: Return to Word and use the query as the source of your mail merge. Let me know what happens, Peter --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com, "Bob Runyon" <[EMAIL PROTECTED]> wrote: > > On the data entry form > > > > CAPITAL AGREEMENTS CORPORATION > > Tele 888. 583. 0400 > > Fax 888. 583. 0401 > > Nationwide Commercial Financing & Leasing since 1989 > > -----Original Message----- > From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] On Behalf > Of phoogenb > Sent: Tuesday, April 10, 2007 2:42 PM > To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > Subject: [ms_access] Re: Field that does not show up > > > > Bob, > > Where is the calculation performed? > > Peter > > --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com, "Bob > Runyon" <Capitallease@> > 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:ms_access%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] > On Behalf > > Of phoogenb > > Sent: Tuesday, April 10, 2007 12:16 PM > > To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > > 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] > > > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
