Sorry, what I think you need is: TotalCom: [Commission1]+[Commission2}
(I was thinking in terms of forms rather than queries.) See if this works. If it doesn't, you could get the SQL view up for the query and let us see that. Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of torres0157 Sent: Thursday, September 15, 2005 11:17 AM To: [email protected] Subject: [AccessDevelopers] Re: Message in Query #Error Tobi, I tried what you suggested but still got #error in the result field TotalCom in the query. What I did was right click the Field name on the form (Commission1)and entered Txt in front of the field name which changed to TxtCommission1 and displays in the Text Box. I also Changed this field names in the query commission1 and commission2. TotalCom: [Txtcommission1]+[TxtCommission2} Do I need to also changed the control source What am I doing wrong. Thanks Armando Torres --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > Have you given the textbox or query field a different name from the fields it references? If you start by pulling a field from the field list onto the form (or use the wizard in starting to make the form), it will have the field's name as the textbox name. Then when you make it a calculated field, it looks to Access like a circular reference, so you have to rename the textbox or field. If you don't, Access gives that unhelpful "#Error# when you go to Form or Datasheet view. I generally add "txt" as a prefix on a form, or some other variant of the field name, and that's enough. > > Tobi > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of torres0157 > Sent: Thursday, September 15, 2005 9:48 AM > To: [email protected] > Subject: [AccessDevelopers] Re: Message in Query #Error > > > Yes, > I think the problem is the fields I am trying to total are > calculated fields. Is this true??? > > Armando Torres > > > --- In [email protected], "robsims99" > <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Something a bit basic, but the field in the form or the field in > the > > table you're getting all the data from or entering into are all > the > > same data type? > > > > cheers, > > > > Rob S. > > > > > > --- In [email protected], "torres0157" > <[EMAIL PROTECTED]> > > wrote: > > > I keep getting an error message #error when adding a commission > > > total in a query to a grand total. > > > > > > any suggestions > > > > > > Armando Torres > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
