Scenerio Anlysis - Basd On User Dates

Hi,

I have an employee table(s) from which i would like to do retention analysis. i have a few queries.

one query gives me all the active employees based on a form (start and end dates). I limit to either those who are still active, those that were terminated after the startdate, and who were hired before the end date.

then i have a query that gives me those terminated during the time frame of start date and end date.

i have another query that divides the count of terminated by the count of active.

i then have another query that gives all three. the last query, the active and the terminated. i then use this query in a report.

i need to report to show it by month between start date and end date. i don't have these month breaks. i am not basing on data that is by month.

how do i do this?

i cannot post the database, simply because the tables are of larger databases.

please help.

thanks,

sam