I have looked through the other threads but have not been successful with my goal. I have a single table with all the data I need, but need it sorted. To achieve that goal I created a report with subforms based on three separate queries. My problem is that all three queries will need an applicable parameter for input.
To make this simpler the database is based on employees time applied to projects and inclusive of sick days and vacation days as well. Essentially I need to be able to enter the days I want the report to apply to (simple Between X and y date parameter query was what I had in mind). Enter the dates and then display on a report the total qty of hours applied to all projects by employee name, number of hours of sick time applied during this time period by employee name and lastly, number of hours of vacation time applied during the timeframe by employee name.
I created a query for each of those fields (work, sick time and vacation) but now realize that a parameter query will work for one of those but the other two also need that data and I would like to not have to enter the data three times.
Any suggestions will be greatly appreciated.
To make this simpler the database is based on employees time applied to projects and inclusive of sick days and vacation days as well. Essentially I need to be able to enter the days I want the report to apply to (simple Between X and y date parameter query was what I had in mind). Enter the dates and then display on a report the total qty of hours applied to all projects by employee name, number of hours of sick time applied during this time period by employee name and lastly, number of hours of vacation time applied during the timeframe by employee name.
I created a query for each of those fields (work, sick time and vacation) but now realize that a parameter query will work for one of those but the other two also need that data and I would like to not have to enter the data three times.
Any suggestions will be greatly appreciated.
