Select multiple entities from a look up table querie issue

[spn200286]

Firstly sorry if the wall of text is abit well walley

I am trying to design a querie which lets you select multiple criteria from a drop down combo box (job skill) so when it runs you are promted to enter skill1, skill2, etc and then shows a table of people with all the skills selected.

i am abit rusty with my SQL (tho i am rebrushing up on it with the many books i seem to ahev baught oevr the years) so imusing the query builder in access.
once i set up the fields i want, i am using the parameter [enter skill here] and it works fine, the problem is if i want rmeo then one skill, i have tried using [text] & [text] but it only asks once for the skill as before.
I have also tried using it in diff columns with the same results

does anybody have any ideas as to how to do this using a look up combo box, (or as this is just a prototype any other sugestions)
I have looked on google breifly but the results can be vague or unrelated, so if u have a way to point i dont mind doing the research myself

or if its SQL statement thats ok also

If you need more info please say

Thsi is not a school project its for a job (there current database software isnt rly compatable with this side branch of the company, so i have been asked to make a quick access database to handle it)

Thanks for any help you can give

 

[jdraw]

Several great video tutorials at http://www.datapigtechnologies.com/AccessMain.htm

Look for the combobox series under Access Forms: Control Basics
combobox1, 2 and 3

 

[spn200286]

Thanks for that link was great (your right some good tutorials on there)
turns out all i needed to do was use instr which solved almost all my problems (it would help to be able to use and insted of or (atm its skill one or skill 2, rather then the desired skill1 and skill 2 if anyone knows would save me some time))

thanks agin for the link