Creating a Select Query to search for Mutliple Values

[ajay_vad]

Hi

I am a bit of a Access Newbie, so this is probably a simple question.

I have a form which is being used to search for Resource Skills. There are three Combo-boxes which indicate Primary, Seconday and tertiary Skills.
If the users selects 'Project Management' from the Primary Skill and 'Ms Project' from the Secondary Skill, i need the Select query to show only the resources which match this.

I am using the below statement in the Criteria to pull the value from the Combo Box [Forms]![Multiple Skill]![Primary_combo].

Can this be done using a Select Query. Would a AND statement be used?

Thanks

 

[MStef]

What is the look of your table ?
What is the primary key ?
Write some records in your table.

 

[ajay_vad]

Hi

I have attached a screen shot of the table with some records

The Primary Key covers 4 fields - Resource, Level 1_Skill, Level 2_Skill, Level 3_Skill

Thanks