Invalid Syntax - Nz Formula (1 Viewer)

I am receiving invalid syntax for my formula. A1, A2, and txtAmount is the name of the text box, and they are general numbers.

I need to (A1*A2,"",Round(txtAmount*1200/A1/A2/0,0))

=Nz(Nz([A1,0],0)Nz([A2],0),"",Round(Nz(txtAmount],0)Nz(1200)/Nz([A1,0],0)Nz([A2],0))

Thank you

in Q1, use NZ on the fields that could be null:
Amt: Nz(txtAmount],0)
A1amt: Nz([a1],0)
A2amt: Nz([a2],0)


then do the calc in another query:
Round(Amt*1200/a1Amt/a2Amt)

Thank you, this formula is in a control source of a textbox.

Spam808 said:

I am receiving invalid syntax for my formula. A1, A2, and txtAmount is the name of the text box, and they are general numbers.

I need to (A1*A2,"",Round(txtAmount*1200/A1/A2/0,0))

=Nz(Nz([A1,0],0)Nz([A2],0),"",Round(Nz(txtAmount],0)Nz(1200)/Nz([A1,0],0)Nz([A2],0))

Thank you

Click to expand...

Because there are a lot of wrong code/statements:
First take away all the NZ so it isn't disturb you, because it seems that you use the function without thinking, then you can built it up piece by piece.

Thank you, this formula is in a control source of a textbox.

Click to expand...

Because this formula requires so much in the way of pre-checking, this is wrong on multiple counts.

First, you are guaranteed further failure because you are dividing by something that will be zero sometimes (if A1 or A2 came up null). So this is totally wrong.

Then, you are letting all sorts of things distract you with the NZ function.

Here is my take. This function, since it is the .ControlSource of the text box, means the text box is unbound. BUT... if the rest of the form includes some bound items and the underlying record contains A1, A2, and txtAmount, you could compute this using VBA to do all of your fancy-schmancy NZ and divide-by-zero pre-checking in the Form_Current event. Then just post the result of the computation in the textbox.