Date range Search of multiple fields

[Spooge]

Hi I am new to access and this form and need some help, I am building Access (2013) database for 100+ employees to keep track of their expiry dates of visa/passport/work permits, for that to work I need to be able to search between date range to generate a report to work on. please check out the image attached as it will explain better where I am stuck, with current settings access keeps giving me empty query table as I think it searches for exact same result in all 3 fields at the same time. But I want it to search between all 3 fields and display if any of the 3 fields falls into that range. Please Help

 

[AlexHedley]

For Query criteria ACROSS like you have it is an AND so the date ranges have to match in ALL 3 Fields.

Try putting each Criteria in its own row, so DOWN, this will be an OR.

It will look stepped
A. B. C
1
2
3

Not
A. B. C
1. 2. 3

 

[Mihail]

Move the criteria for "VisaExpiry" one row down and the criteria for "LabourCardExpiry" two rows down.

As there are now you have an AND between criteria.
By moving as I say, you will obtain an OR between criteria

 

[Spooge]

It worked, Thank you guys so much.