The table has all the data in it.
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 5:24 PM To: [email protected] Subject: [ms_access] Re: Field that does not show up 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 [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.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: [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 3:23 PM > To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.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] > [Non-text portions of this message have been removed]
