I have an employee database that I am making and need a little help. Right now I have separate queries for Vacation Eligible, Benefits Eligible, and Birthdays pulling this month and next month for a total of 6 queries. Each query has Employee Status, EmployeeID, Employee Name and the corresponding date. I have tried to do a union query and was unsuccessful because when it does return a date I have no idea if it was a birthday, vacation or benefits date. I have also tried making one query with all 3 dates and get stumped on how to continue. My end goal is to run a report that will have the 3 fields listed and the employees with the current month criteria underneath. Is there a way to do this all in one query or two (current & next month) or am I stuck with a bunch of queries? Thank you in advance!