Problems using the Sum function on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

sAre there any known problem with this function? I am trying to sum a
numerical field on a slightly complicated form, but get #Error. If I create a
simpler form, with exactly the same box for the sum, it works fine, but
cutting and pasting the box to the more complicated form, I get #Error again
(both forms based on same data, etc).
 
Does the control have the same name as the field to which it's bound? Make
sure that controls on forms and reports don't have the same names as the
fields in the record source. When you try to reference the control, Access
doesn't know if it's the control or the field you're looking for. So, if
your field is called Amount, then name your text box txtAmount.
 
No, control has a different name, eg if field is Qty, control is called SumQty
 
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

Sum If function in textbox 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
The Sum command gives an error 2
SUM on a Form 2
Access Sum function in an Access Form 1
Sum() 5
#Error on calculated control in a form 2
Using DSUM to get running total on a filtered form 0

Back
Top