Filter report by more than one date field

M

Mic Greenbriar

I have a report based on a query that I want to filter using date fields.
The report has three date fields in each Demised Premises Record
(DemisedPremiseID is the unigue id for each record): RenewalNoticeDue,
TerminationNoticeDue and PurchaseOptionDue. I want to run the report to show
me which records have any notices due within the next 13 months. I imagine I
would do this from an unbound form but not sure how to code this. I know how
to filter a report using a date range etc. but this one I am not sure about.
I am new at this so bear with me. I hope I provided enough information.
Thanks for you help in advance.
 
Top