if expression 1

[ocan]

I have a query, the query includes 2 fields: Actual Ship Date and Requested Ship Date and I am trying to build an "If" expression to create another field.

Expr1: IIf([Actual Ship Date]=Null,[Requested Ship Date],[Actual Ship Date])

The above expression is doing the false part, but not the true part. Can someone give any insight?

 

[PHV]

Either:
Expr1: IIf([Actual Ship Date] Is Null,[Requested Ship Date],[Actual Ship Date])
Or:
Expr1: Nz([Actual Ship Date],[Requested Ship Date])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ocan]

Perfect. Thank you very much.