Report to display certain fields if another field is null

[qshaz]

Hello

I am required to do this in my report:
There is a date that I am supposed to show in the report. In my table, I have two dates - one is end date, and the other is deposit end date. I want my report to show end date if end date is filled in, and if end date is blank or empty, then to whos deposit end date (the user who enters will only enter one of these).

I have no clue how to do this in the report! Can anyone help me please?
Thanks!

 

[DonQuichote]

you can use the iif function for that. Just set a field's rowsource to an equal sign, followed by this function. Suppose the table that your report is based on has three fields: endDate, valueIfGiven and valueIfNotGiven. then you make a textbox on the report and set the rowsource to:
=iif(isNull([endDate]),[valueIfNotGiven],[valueIfGiven])

Do not forget the equal sign.