Hello, I have a table called change_order_dates that contains the following.
Change_Number Project_Number ShipmentNumber Current_Delivery_Date New_Delivery_Date 201 1020 1 31/07/2014 31/07/2014 201 1020 2 07/08/2014 14/08/2014 202 1020 1 31/07/2014 31/07/2014 202 1020 2 14/08/2014 14/08/2014
I also have a report that displays all the change orders for a specific project:
Do you see that unbound New Delivery Date(s) field? I would like it to have the value 'yes' if a new delivery date has been added for that change order. So for the above table, Change order 201 would have a 'yes' but change order 202 would not since non of the dates changed.
Let me know if there is a way to do this, thanks.