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
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
