Hi friends
I have three delivery dates in my form. Customer DD(Given by customer), Our DD(agreed by the us, the company) and Revised DD (in case the DD has been revised).
But have one field in the report to show the DD. Now the logic behind is that the field should display the Revised DD but if Revised DD is Null then it should display the Company's DD and if that is also Null, then it should take the value of Customer DD.
How to do that? Through vba? and how? Plz guide me.
Thanks
I have three delivery dates in my form. Customer DD(Given by customer), Our DD(agreed by the us, the company) and Revised DD (in case the DD has been revised).
But have one field in the report to show the DD. Now the logic behind is that the field should display the Revised DD but if Revised DD is Null then it should display the Company's DD and if that is also Null, then it should take the value of Customer DD.
How to do that? Through vba? and how? Plz guide me.
Thanks