Can I do a select case for more than one field?

[Guest]

In looking at examples of select cases, I'm always finding it set up for one
field. I need to look at 2 fields per case. In this example, I need to look
at the results of a count of records for each employee as well as the name of
the position, then check it to see if I'm getting the right number of records
as per the position name. Sales reps should have 7 records, account execs 5,
etc. If it isn't the correct number of records, a text message to flag the
employee should appear.
I could do a complicated IIF statement for it, so I should be able to do a
select case, but how is it worded when you're checking 2 fields in each case?

Think that's it for today, but never say never.

 

[Guest]

Create a reference table with fields for Position and record count. Use a
totals query to display the employee, position, and count of records. Then a
second query comapres the count to the reference table for the position..