MSAccess Classification by Incidents — OZONE Asylum, home of the Mad Scientists

OZONE

MSAccess Classification by Incidents

This page's ID: 30545

Edit Post

Who can edit a post?	The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	Consider the following MS Access table: DATE, EMPLOYEE NUMBER, INFRACTION 01-Jan-08, 1, Missed Deadline 02-Jan-08, 1, Missed Deadline 02-Jan-08, 2, Out of Uniform 02-Jan-08, 1, Out of Uniform I want to be able to classify employees are GOOD, AVERAGE, or BAD based on their infractions. I want to classify 2 ?Missed Deadline? incidents in the past 6 months as BAD, while only 1 is AVERAGE. If they have 1 ?Out of Uniform? in the past year they are BAD, even if they have no ?Missed Deadline? incidents. If they are BAD in any category, then they are BAD; if they are otherwise GOOD but have AVERAGE in any one category then they are AVERAGE, etc. I?d like to be able to view a list of all the employees (by their number) with their level next to them. I hope that was not confusing. This is a simplification of what I'm trying to do, it's complex and work-related (and nothing to do with employee infractions). Heh- if I ever found myself tracking employee behavior in Access I have a stiff drink laced with cyanide. I have no idea how to start doing this in Access, though I have all the data to do it. Does this make sense? Does anyone know how to have Access give me such a list? [small](Edited by [url=http://www.ozoneasylum.com/user/418]Petskull[/url] on 09-14-2008 17:17)[/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu