using records in table as query criteria

[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

 

[chas]

Hi Z,

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

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

hth

chas