Advanced Filter Criteria Parameter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to filter a table according to values in a field labeled
PropertyID that correspond to values in a field on a second table also called
PropertyID (I only want to see the records in table one that have the same
ProperyID numbers that are in table 2)

So I did an advanced filter and used the PropertyID field in table 2 as my
criteria, but when I apply my filter, it asks for a parameter value. If I
enter one of the PropertyID numbers from table 2 then it will filter table
one down to that single record, but table 2 has 2,000 PropertyID numbers and
I want to see all of the records in table 1 that match the 2,000 records in
table 2. How do you specify that your criteria should be all of the values
under the criteria field?

If you can actually understand my ramblings - please help!!!
 
You need to specify the criteria on your table2's
PropertyID field similar to the following:

In (Select Distinct PropertyID From table1)

HTH
 
Back
Top