Populating a report field when a certain field is Blank

[wan2fly99]

I would like to fill in on a report the field say: Return Date.

Return Date has values coming in from a query, but if the query value
is blank, then I want to show
Return Date as: 15 + [Date Out] which is another field on the report

How can Ichange the control source to say put an if statemnt maybe to check if Date Return is blank, then format field this wasy
else show value coming in

Do I put some code in an event maybe? If so which one?

Thanks for any help

 

[wan2fly99]

The best way would be to modify your query to return the values you want .

Okay, except the Return Date field has values in it, when it is blank then I want to replace it with the Date out field + 15 days

 

[WayneRyan]

wan,

How about adding a new field to your query?

NewField: IIf(IsNull([ReturnDateField]), DateAdd("d", 15, [Date Out]), [Return Date Field])


Then, just use that in your report.

Wayne