@Cronk @theDBguy @jdraw
https://drive.google.com/file/d/1FtK9gtCIApNDBuAif1xsyoHDOS3HdkOK/view?usp=sharing is the database due to it being too large for the site.
Above is the access database, have stripped it and removed 204 employees. I am going to take the advice and change names to no spaces and have identifiers (cbo,txt, etc.) once I figure this out and show my proof of concept to my team and boss.
As I'm sure you all know using macros will be asked to be enabled, if you do it will hide all options, in that case, hit "Tools" and enter password "hide". This is so that my staff won't be overwhelmed or enter data where it is not meant to be.
This database was built with the "Student" template but modified quite a bit to fit my needs.
Attendance is a huge issue at my work, and tracking is a disaster. The database is basically outfitted to use exclusively by my staff in the "Employee Menu (Form Name Employee Details). Opening this will default to a blank "Add New Employee" screen. Select one of the names in the dropdown at the header or search by name, number, etc. Anyways!, when I select myself (Dawson, RHODES) I will use the "Attendance Detailed" tab to track all instances and use the "Attendance Viewer" tab to see a general overview for each employee. In that "Attendance Viewer" tab, there are two subforms, they are copies of each other but one is used strictly for the datasheet view, and one for the header which is the "Statistics".
The subforms are linked to the "Employee Attendance Extended" query. In this there is a date formula to calculate the number of days between the absence start date and end date. That data is used in the "Statistics - Days on Leave" box's control source. This works great because when I open the "Employee Menu" this number varies based on which employee is being selected!
So here is exactly what I want to do...
Create a working formula to calculate the
number of days an employee is absent based on what type of leave they are on... Sick, Emergency, etc., which likely needs to be built right into the query as suggested, but I have been unsuccessful.
(( I now realize it has to be built into the query or else it will calculate all entries and will not vary between employee to employee. I have successfully coded this using "Criteria" but that then makes it only show entries in the query that match leave type of "Sick", which I do not want. ))
If you are planning on downloading and seeing the database be advised that because all the users have been stripped, there are only 2 attendance records, and you may need to add several to both AWA and RHODES in order to generate some records. This can be done directly in the table or in the "Menu" in the second tab!
I hope this helps and makes sense and I hope you guys can assist me as I am still learning but and amazed how much I now understand about basics!