I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the employee badge number, points accumulated (either 0.5 or 1), reason, and comments. Apart from the point values I would like to add the disciplinary level, which is as such,• Level 1 - Oral Warning (2 points within thirty (30) days) • Level 2 - Written Warning (1 point within thirty (30) days of Step 1) • Level 3 - Three (3) Day Suspension (1 point within thirty (30) days of Step 2) • Level 4 - Dismissal (1 point within thirty (30) days of Step 3) But also, 30 days goes by and no point has occurred than it reverts back to the previous level. I would like to write a query that calculates and assigns the disciplinary levels, but am not sure how to go about it. I need someone to point me in the right direction. Hoping help is out there, Katie
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!