finding records that match multiple criteria

[adriancarnu]

Hi, I have a personell DB an I vant do be able to select only the persons from a specific "city" with a specific " genre" and a specific "skill" and also i want the query to "ignore" one of the criteria if I press Enter or input all.
I tried with "query design " and I don't seem to make it work for more than one condition.

Thanks

 

[neileg]

There are samples showing how to do this in the Sample Database section of these forums.

 

[adriancarnu]

The examples are a little complicated for me but i'll try to manage.

Thanks!