L
Liz McCracken
Sounds like a problem in the underlying query....try
running the query and see if you get the same error.
Also, when putting the sum on the report be sure to
enclose the field name (expr1) in square brackets inside
the round brackets. ([expr1])
I have gotten this error when there was a field in my
underlying table that had a zero in the field and my query
wasn't looking for the zero. You can avoid this by using
the nz function. You can read up on the nz function in
Help.
Good Luck!
Liz McCracken, MOS
running the query and see if you get the same error.
Also, when putting the sum on the report be sure to
enclose the field name (expr1) in square brackets inside
the round brackets. ([expr1])
I have gotten this error when there was a field in my
underlying table that had a zero in the field and my query
wasn't looking for the zero. You can avoid this by using
the nz function. You can read up on the nz function in
Help.
Good Luck!
Liz McCracken, MOS