display field based on condition (1 Viewer)

[Khushalay]

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

 

[moke123]

you could try nested iif's or Nz() or switch().
I like switch as its easiest to read.
something like...

Expr1: Switch(Not IsNull([RevDD]),[RevDD],Not IsNull([CompDD]),[CompDD],Not IsNull([CustDD]),[CustDD])

substitute your field names for mine.

 

[Khushalay]

Sorry for being naive but do I have to write this in Query or Coding? If in coding, which event?

 

[Khushalay]

Thanks alot

I put it in Query and it worked perfectly.
Thanks once again

 

[moke123]

yes, that was for a query.
your welcome and good luck with your project.

 

[Khushalay]

Thanks for the help