Calculated Sum in Form

[TimC]

I am trying to create a calculated field in a form that will total or sum 6 different fields pulled from either the form or associated query. In some cases, the fields may be null or contain a value. The value of null will always be zero. I have already tried the following:

ProposedPenalty:[Fine1]+[Fine2]+[Fine3]+[Fine4]+[Fine5]+[Fine6], but this only works if/when all fields contain a value. I have also attempted to add Nz([Fine1],0) +NZ([Fine2],0) +NZ([Fine3],0) +NZ([Fine4],0) +NZ([Fine5],0) + NZ([Fine6],0) into the control source line, but I did not have any luck. I am a newbie and simply need some help. Any suggestions? Thanks.

[June7]

Expression looks fine to me. What do you mean by 'did not have any luck' - error message, wrong results, nothing?

If you want to provide db for analysis, follow instructions at bottom of my post.

[TimC]

Please see the attached dB..... Is there any cost to you looking at my dB? If so, I may need to rethink this. Thanks.

[June7]

Place an = sign at beginning of expression in ControlSource. See the little box with ! mark next to control? This is providing a note about this error.

No cost, participation in forum is voluntary for posters and responders.

[Bob Fitz]

I am trying to create a calculated field in a form that will total or sum 6 different fields pulled from either the form or associated query. In some cases, the fields may be null or contain a value. The value of null will always be zero. I have already tried the following:

ProposedPenalty:[Fine1]+[Fine2]+[Fine3]+[Fine4]+[Fine5]+[Fine6], but this only works if/when all fields contain a value. I have also attempted to add Nz([Fine1],0) +NZ([Fine2],0) +NZ([Fine3],0) +NZ([Fine4],0) +NZ([Fine5],0) + NZ([Fine6],0) into the control source line, but I did not have any luck. I am a newbie and simply need some help. Any suggestions? Thanks.

You need an equals sign = before the expression.

= Nz([Fine1],0) +NZ([Fine2],0) +NZ([Fine3],0) +NZ([Fine4],0) +NZ([Fine5],0) + NZ([Fine6],0)

[Bob Fitz]

Sorry June7. You type too fast.

[TimC]

Thank you.