Toby, can you add a total field into a query/table and use this field to store accumulated totals of calculated fields. Thanks Armando
--- 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
