if null then x

[Guest]

I have a query with two equation fields, QTY1 and QTY2. I would like to have
QTY2 take the data from QTY1 only if QTY2's result is null. Is this
possible??

Thanking you in advance,

 

[Guest]

Yes.

IIf(IsNull(QTY2)=True,QTY1,QTY2).

Luke

 

[Guest]

=nz(QTY2,QTY1)

 

[Guest]

Thanks a lot

Yes.

IIf(IsNull(QTY2)=True,QTY1,QTY2).

Luke

 

[Guest]

You can also use the Nz function, but beware, as it converts integer to
string. Therefore, depending on the value (if decimal or not) you may have
to use conversion function, something like CLng(nz(QTY2,QTY1)).

Luke