using records in table as query criteria

  • Thread starter Thread starter Z
  • Start date Start date
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
 
Hi Z,

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

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

hth

chas
 
Back
Top