REALLY dumb question

  • Thread starter Thread starter kryszystof via AccessMonster.com
  • Start date Start date
K

kryszystof via AccessMonster.com

Good Day!

I am having problem with sum() function, yes, i said the sum() function. I
have small form that lists info based on criteria, and displayed on a
continous form, and then those numbers are totaled at bottom. I have four
forms per week, and two work fine, and two say *#Error*. i have deleted, and
added them again, check my naming of fields, syntax. i even check every
setting between form that work and form that doesn't. they seem to be the
same, but i must be missing something. i think i'm going crazy!! TIA ~ K
 
Is it possible that one or more of the values in the fields are Null? Use
the Nz function to convert them to 0, if that's the case.
 
kryszystof said:
I am having problem with sum() function, yes, i said the sum() function. I
have small form that lists info based on criteria, and displayed on a
continous form, and then those numbers are totaled at bottom. I have four
forms per week, and two work fine, and two say *#Error*. i have deleted, and
added them again, check my naming of fields, syntax. i even check every
setting between form that work and form that doesn't. they seem to be the
same, but i must be missing something. i think i'm going crazy!! TIA ~ K
Click to expand...


Double check the field types to make sure they are numeric,
you can not Sum Text fields.

Also make sure you are summing a **Field** in the form's
record source table/query and not another control on the
form.
 
Back
Top