Can anyone help me with this query

[KC744]

Can anyone help me with this query please!!

I have a table called "Jobs List", included in that is a field called Word Processing (Text field)which is a combo box, the entries in there are "Low","Average" and "High".

I also have another table called "Personnel" which has the same combo box.

What i need to do is in the criteria in the query, is only find records in personnel's word processing field that are equal to the word processing field in Jobs List's word processing field.

I think the line I need to enter in the criteria of "Word processing, Jobs List" is something like "=Personnel.Word Processing.Text" but am sure sure of the correct syntax, Please help if u can, it will be much appreciated.

 

[ghubbell]

Hi there!
Not too sure if I follow you but you might try this:

=Forms[NameOfYourForm]![NameOfYourComboBox]

If I'm on the right track, be careful that the bound column in your combo is in fact the column that contains the data you need.

Write back if we're going somewhere or not! Gord
ghubbell@total.net

 

[Psychpt]

if you're looking for help building a query, there is a wonderful query builder/helper available for download at:

http://www.mvps.org/access/forms/frm0045.htm

It is a very valuable tool for beginners.

HTH

PsychPt@Hotmail.com