Hi Bob, Are you looking at the FORM in datasheet view, or at the TABLE in datasheet view?
If the FORM, then try looking at the table. If the TABLE, then I have misdiagnosed your problem. Peter --- In ms_access@yahoogroups.com, "Bob Runyon" <[EMAIL PROTECTED]> wrote: > > 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" <Capitallease@> > 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] >
