The end goal is to hook Tableau up to the database and start reporting head count stats. Eventually,
Stats such as;
- How many FT vs PT employees.
also trend because I'm adding a hire date and a term date....
So here is the help needed......
- I need a form that can be used for "Employee Entry" where 3 pieces of data will be entered. (Short Name, Last and First)
- I need a form that can be sued to take the employee that is entered and attach the department, group, hire date etc.... to it. This table is set up called Employee_Reporting
- How do I incorporate a "changed" date into this. Because there have been times enployees go from FT to PT or vis versa?