Print Report in range of dates and more

[Sakhikid]

I need to print out a report from a start to end date. But theres a catch i also need to print those items from previous months that are not yet resolved. I have a checkbox that tells me if the record has been resolved or not. Is there a way that I can put both the conditions into my query, one for the dates of transactions and the other being all outstanding items no matter what the date.

 

[Pat Hartman]

I find it easier to use SQL view to enter complex criteria so switch to SQL view.

Select ....
From ...
Where (SomeDate Between [Begin Date] AND [End Date]) Or (SomeDate < [Begin Date] AND Resolved = False);

 

[Sakhikid]

Perfect!!!
Thanks alot