Query with optional and must criteria

[perlfan]

Hi,

It would like to filter employees - the first two criteria make sure a certain language pair is met (must criteria) and a third criterium contains a field of expertise. Every employee can have up to three fields of expertise whereas only one of them must match the selected criterium in the form.

Now my question is - how do I build such a query where two criteria are not optional and one out of three table fields must contain the third criterium? Thanks for help...
FRANK

 

[Beetle]

SELECT * FROM YourTable WHERE [Field1] = "this" AND [Field2]="that" AND ([Field3]="the other" OR [Field4]="the other" OR [Field5]="the other");