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	Think 300 employees and dozens of infractions per day. The data is already in Access and updated daily. The table presently has tens of thousands of records. While I can put them into Excel, what I need is that list of 'Employee 26 -> BAD', and I'll need it several times a month. The problem is that I need to apply a set of rules in order, so it's not a simple SQL query. Instead of a Missed Deadline in the last year or an Out of Uniform incident in the past 6 months, I need to check 13 different categories and come up with an 'Overall Employee Rating' for each guy. The good part is that if he has a 'Missed Deadline' in the past year, then I can tag him BAD and not even worry about the rest of the categories. However, I need to be able to disregard 'Out of Uniform' incidents before 6 months ago even though I need to include Missed Deadlines during all of the past year. Right now I'll go thru each incident for each employee and count one by one, which sucks. I was hoping to automagify this process but I don't even know where to start. Do I need a form in Access with some VB code? Just SQL statements somewhere? Is there already a GUI way of doing something like this? Etc, etc.. It's a simplification only in that this is the exact problem that I'm trying to solve. In other words, solving this problem would resolve my whole situation. The rest of the context of this is difficult to explain, but irrelevant to what I'm trying to do. Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu