If the working window doesn't match 10am-14pm but *overlaps* portion of it, do you want your query to return it?

For instance, if a worker works during 13:59pm to 18pm, or 12pm-16pm, or 10:01am to 14:01pm, then technically none of these are the same window as 10am to 14pm.  

If your query doesn't accept such overlapping, then it is a much easier query to make.  You simply make a criteria where a worker's start time and end time are BOTH less than 10am *or* BOTH greater than 14pm.

But if you accept overlapping, then it will complicate matters.

Thanks Kevin. The working hours are 08:00-16:00. But what I want is that if a person is absent like 10:00-12:00, just two hours. We ca forget the minutes, it's enough with hours. How can I filter this query? Later I want to make a combo based on this.

OK. I tried ChatGPT and it returned this:

To filter the query in MS Access based on a person's absence for just two hours, you can use the "DateDiff" function to calculate the number of hours between the start and end time of the absence, and then use a filter to show only those records where the difference is equal to two. Here's an example query:

SELECT * FROM [your table name] WHERE DateDiff("h", [absence start time], [absence end time]) = 2;

Replace "[your table name]" with the name of the table that contains the absence data, and "[absence start time]" and "[absence end time]" with the names of the fields that contain the start and end times of each absence. This should give you a list of all the records where the absence was exactly two hours long.

I don't want to do this for a person. I want to automate this for everybody. Thanks!

What data does your table have about your staff, and what data do you want your query to give you?  In other words, what do you mean by "displaying your people" with the query?  I thought your table simply had your workers' daily start time and end time.  But from your description, it seems you table has a different kind of data.

Thanks Kevin. I have start date and end date. For example if a person is absent between 10 am -11 am but working before after and after that time. How can I filter that?

Again, you need to show me what your table's fields and data look like, because what I think they are seem different from what you have.  Please show me something like:

WorkerID    StartTime    EndTime
1000        10am         14pm
1001        9am          13pm
1002        11am         16pm

The above is just an example.  Show me what your table or tables look like exactly.

Dear kevin, here are my table and query. Thanks for helping me out.

I don't quite understand the need for the times of absence.  Their working hours should be enough to indicate their absence.  If I work from 9am to 5pm, it is automatically clear that my absence is 5:01pm to 8:59am, isn't it?.  Why do you need to specify absence in your table?  Also, what type of results do you want your query to return (please show me some data)?