Match Suitable Records for "Link9"

[KC744]

Thanx for your reply, i've tried the statement you gave me but i can't get it to work. So i have included a sample of what the tables look like the the field names included.

(Name of table is "Jobs List&quot
Name Data Type Field Size

Job Title(Primary Key) Text 4
Word-Processing Text,Combo Box(Low, Average, High)
Typing Text,Combo Box(Low, Average, High)
Filing Text,Combo Box(Low, Average, High)
Shorthand Text,Combo Box(Low, Average, High)
Book-Keeping Text,Combo Box(Low, Average, High)

(Name of table is "Personnel&quot

Emp No(Primary Key) Text 4
Word-Processing Text,Combo Box(Low, Average, High)
Typing Text,Combo Box(Low, Average, High)
Filing Text,Combo Box(Low, Average, High)
Shorthand Text,Combo Box(Low, Average, High)
Book-Keeping Text,Combo Box(Low, Average, High)

What I need to do is find all the employees' that have a skill level that is equal or above to the corresponding fields in Jobs List.

Thanks for all of your help in this I really appreciate it. If you know how to solve this, or know of a better way to do this please let me know. Cheers!