Hi Everybody--
I'm new to working with access, so please forgive my ignorance.
Anyway, I have created a database to track employees and vacation time. I have a table for Employees and Vacations. I have a query that calculates an employee's anniversary date each year, a query that sums up total hours for each employee and subtracts that from available to give a balance for the vacation year, and a query to view the vacations for a specific employee over a date range.
The problem comes in with my report. I am trying to create a report for an employee's vacation (VacationsByEmployee), and all works well until I add criteria to the date. If there is a vacation during this time, there is no problem, however, when there is no vacation, an employee's name does not appear on the report and it is blank. I think this has to do with how I have my queries set up. Any guidance would be greatly appreciated. I have attached a copy of my database thus far.
Thank You!
I'm new to working with access, so please forgive my ignorance.
Anyway, I have created a database to track employees and vacation time. I have a table for Employees and Vacations. I have a query that calculates an employee's anniversary date each year, a query that sums up total hours for each employee and subtracts that from available to give a balance for the vacation year, and a query to view the vacations for a specific employee over a date range.
The problem comes in with my report. I am trying to create a report for an employee's vacation (VacationsByEmployee), and all works well until I add criteria to the date. If there is a vacation during this time, there is no problem, however, when there is no vacation, an employee's name does not appear on the report and it is blank. I think this has to do with how I have my queries set up. Any guidance would be greatly appreciated. I have attached a copy of my database thus far.
Thank You!
