Multiple Iif to control report output

J

jhicsupt

I have a report based on a query.

Order Number
Order Date
Delivery Date

I want to include records that fit the below criteria
Iif Order Number = "111" and Delivery Date - Order Date >=10
Iif Order Number = "222" and Delivery Date - Order Date >=100

Thanks in advance.
 
Top