• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

access query to get employees from database


I have a database, I need to run a report on employees who are on holiday at a specified date.

The report works great, and is picking up everyone who is on holiday on a specified date...

the problem I have, is that holidays are entered in advance, and when someone leaves the company, they are still showing up in the report.... I could exclude them in the query, but that would affect the results when they were an employee and had a holiday... soo..

my employee table has a field named employee_status, and status 1 is live, 3 is leaver

I also have a field in employees table for leaving date, this is either 01/01/1900 if the employee is live or the leaving date if they left.

so... how can I incorporate into the query that information, so that the query will show any holidays for any employee when they are 'live'?
  • 2
1 Solution
Gustav BrockCIOCommented:
Apply a filter: where leavingdate = #1/1/1900# or leavingdate > holidaydate

cycledudeAuthor Commented:
Gustav BrockCIOCommented:
You are welcome!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now