Hello,

I have 10 optional numerical fields on a form.
When I try to sum them in the control source of another input box, or
even using VB, I only get a working total if all 10 fields contain a
number.

How do I tell access to ignore fields with no number entered and also
fields containing "#Error?" so that I always get a total in the total
box?

Thanks
Ciarán

Cron wrote:

You probably need to use NZ().
=NZ([fld1],0)+([fld2],0)+([fld3],0)...
I wouldn't know. Most people would fix the #Error.

Helper
http://www.youtube.com/watch?v=j3Hf_OclE8U

On Jan 21, 4:12 pm, Salad <o... (AT) vinegar (DOT) com> wrote:
Ha ha the error was actually caused by the same problem somewhere
else! I used an IIf (which I just discovered!) to fix the error and
then the Nz function to fix the totals problem. Thanks a lot for the
help guys!
Ciarán