if null then x

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
Back
Top