I’m trying to see which work orders have material on order and when it is due in. About 50% of our orders
need me to order material and for the other 50% we have material in house.
The IIF statement I am using looks like this:
OrderDate: IIf(([tblPurchaseOrderLineItems]![WorkOrder])>0,[tblPurchaseOrdersMainHeader]![Order/ChangeDate],”Allocated”)
With 0 being the default until a work order is entered into the column.
The result I get is every work order is “allocated”.
Before I was just getting the work orders in which we ordered material.
I want every work order to show up in one column, the order date in another and the due date in a third.
Any ideas?
I appreciated any help.