#Error in form calculation

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

I get #Error in a simple =sum([Field1]) calcualtion in a
form's footer. Same formula works just fine in another
form. What could be a reason for the formula to error, and
what are common causes for #Error in Access forms?

Very much appreciate the help! Deadline tomorrow morning!

Max
 
Max,

If the name of your control is Field1,
change it to something else, i.e. txtField1
You will get an #error if the name of the control
is the same as the name of a field used in your expression.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Field now Error 2
Calculated field in Forms 16
Total Detail on Continuous Form 2
Calculated Field in Form 6
run sum in the form 4
compare calculation to a minimum number 1
Show calculation from main form in sub form 2
SUM on a Form 2

Back
Top