calculated unbound field

[Dgavilanes]

I have an unbound field =[July1]+[August1]+[September1]+[October1]+[November1]+[December1]+[January1]+[February1]+[March1]+[April1]+[May1]+[June1].
However some of this months do not have any entries, so I do not get a total unless I manualy ad a zero where needed.

How would I approach this issue?

Please advise

Dennis

 

[John Big Booty]

Try using the NZ() function on each month field to change a null result to 0.

 

[Dgavilanes]

Hi John,

Thanks for the quick reply. I have never been able to write code succesfully, so my q? is the nz() function goes in the control source Ex: nz(July1,0ifnull]) or does it go in the event procedure before update?

Please advise,

Dennis

 

[DCrake]

Nz([July],0)+Nz([Aug],0)

 

[Dgavilanes]

When I inserted,

Private Sub TOTAL_BeforeUpdate(Cancel As Integer)

Nz ([July1], 0) + Nz([August1], 0)

End Sub

I get a syntax error.

 

[DCrake]

Did you preceed it with Me.UnboundField = Nz(...) + Nz(...)?

 

[Dgavilanes]

No, I did not, however when I Typed (see below) in the control source, it worked.

=Nz([July1])+Nz([August1])

 

[DCrake]

Which is correct. My previous post was VBA syntax not as per your requirement in the control source

 

[Dgavilanes]

Thank you for your help, I really appreciated and I learned something new what's all about

Dennis