|
|
Posted by Nate on 01/18/07 15:50
I am using a table, called 'dashboard', to track employee evaluations.
There are many columns in the table, some of which are populated with
one of four responses:
"Meets Expectations", "Below Expectations", "Not Observed", "Policy
Violation"
I would like to create a query that will search for any employee that
has two "Below Expectations" in the SAME column in a span of 30 days.
I was thinking of using CONTAINS, but that would require me specifying
EVERY one of the evaluation critera (live_1, live_2.. all the way to
live_8.. then review_1, review_2... review_11)
Any ideas?
Navigation:
[Reply to this message]
|