Complex Search Form

Hello! I am trying to build a search form, based on a table.

Here's the table layout:

Employee Competencies
---------------
EE Name
Competency
Proficiency
Years of Use
Recency of Use

I need to be able to select multiple competencies, and/or associated levels (the rest of the fields). At first, I did a filter by form, but the problem with this is that I can only search "OR's" and I need to be able to search "AND's" as well.

Here's what I want: Basically, a user would select six competencies and associated levels, and the form would open to a report listing each of the matched employees' competency sheets.

I've tried query by form, as explained on the Microsoft Knowledge Base and it doesn't work. I'm going to try to upload a stripped down version to make things clearer. I'm desperate and running out of time. Thank you for any help!

Okay, my file's too big to upload, so hopefully, I've described this well enough. Thanks!

KellyJo