using records in table as query criteria

Z

Z

hi
I have written a simple query. I have a field "Branch
Name". As criteria for this field, I would like to use all
the branch names in a Table called "Branch Feedback". How
do I write the expression for this?
Thanks for your help
Z
 
C

chas

Hi Z,

try putting something similar to the following in the
query criteria:

In (select [FieldName] from [Branch Feedback])

hth

chas
 
Top