Check dates for report

[Bob500]

Hi,

How would I go about running a report that checks a table based on 3 dates, the first the date sent, the second the date expected and the third the date received.

Basically if there is no date in date received and the current date exceeds the date expected then It must be included in the report. Any ideas, I am stuck and this needs to be done like yesterday :/


Many thanks.

 

[dhookom]

Try set the criteria under the DateExpected to:
<IIf(IsNull([DateReceived]),Date(),[DateExpected])

Duane
MS Access MVP