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

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	I think the code would look something like this: SELECT WHERE Date >= "1 Year Ago" IF EmployeeLevel < BAD THEN If infraction = "Missed Deadline" then EmployeeLevel = BAD END IF IF EmployeeLevel < AVERAGE THEN If infraction = "out of uniform" then EmployeeLevel = AVERAGE END IF SELECT WHERE Date >= "6 Months Ago" IF EmployeeLevel < BAD THEN If infraction = "out of uniform" then EmployeeLevel = BAD END IF ....but I wouldn't know what to do with it. Where does it go? Do I even really need to code at all? How do people usually do something like this in Access? Loading...
Options:	Enable Slimies Enable Linkwords

Edit Post