Query criteria from table

[rickyoswald]

How do I set the Criteria of a Query to that of text in a field on a table? The MSDN has suggested;
In("Canada", "UK") For a ShipCountry field, orders shipped to Canada or the UK
In(France, Germany, Japan) For a CountryName field, employees living in France or Germany or Japan

Which to me makes no sense as I don't have the database they are discussing! I had a brief look around for related info on this site but could not find any.

 

[rickyoswald]

Possibly (SELECT [FIELD] FROM

)
I'll get my DB man to try it and tell you if it works!

 

[rickyoswald]

It does work.

Here it is again:

To set the criteria of a query to that of the data in a field on a table simply enter the criteria as;
(SELECT[Field]FROM

)