REALLY dumb question

  • Thread starter kryszystof via AccessMonster.com
  • 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
 
D

Douglas J. Steele

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.
 
M

Marshall Barton

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.
 
Top