Date range Search of multiple fields (1 Viewer)

Spooge

New member
Local time
Today, 03:29
Joined
Nov 24, 2013
Messages
2
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:confused:
 

Attachments

  • 2w3dybs.jpg
    2w3dybs.jpg
    95.4 KB · Views: 640

AlexHedley

Registered User.
Local time
Today, 00:29
Joined
Aug 28, 2012
Messages
171
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

Registered User.
Local time
Today, 02:29
Joined
Jan 22, 2011
Messages
2,373
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
 

Users who are viewing this thread

Top Bottom