Good Morning, I have a form using a query and trying to accumulate totals for a commission field for a particular project No. The commission field for each employee is created when the user enters data on a form. The commission field is in a table and is calculated fine but in the query when I try to add these fields I get total the total field in the query has #Error. If there is one field that has a value or no value the total amount is fine, but if there are two or more fields to be added the #Error is displayed. Maybe I am trying to add these fields before they are being calculated on the form. All the fields are spelled correctly. Can someone please help and give suggestions as what to look for: Thanks
A.T. ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
