Hello, I am not familiar with Access and was asked to create a db for attendance. I thought I was done and then was asked to add a column to calculate the number of occurrences by employee, simple enough or so I thought. I have a table which has employee names, time in, earning code and total hours for each line. So assume Employee A worked from 8:00a- 12:00p and the earning code is "Regular" with 4 listed in the total hours for that line. Now, Employee A left early for the rest of the day so the next row would look like Employee A- 12:30p-4:30p- "Unpaid Time" (as the earning code) and 4 for total hours. The 4 hours coded as "Unpaid Time" should result in 0.50 of an occurrence.
What I need is another column added now named 'Occurrences' which is going to calculate all rows that contain the earning code " Unpaid Time" and look at the number of hours to determine how much of an occurrence this will be. So the occurrences are calculated in quarters based the number of hours.
0.5 minutes to 2.00 hours = 0.25 of an occurrence
2.01 to 4.00 = 0.50 of an occurrence
4.01 to 8.00 = 1 occurrence
I am so lost someone please help, thank you!