Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#Error result of Sum function

Status
Not open for further replies.

jaaret

Instructor
Jun 19, 2002
171
I am attempting to sum a currency field with =Sum([EFees]) in the form's header but it is returning #Error. The underlying query does not have any nulls in the EFees field and I can successfully build a summary query off of the query that contains the form data. What is causing the #Error?
 
The error is caused by Sum. Do a help search on the DSum() function.

"Business conventions are important because they demonstrate how many people a company can operate without."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top