If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Advanced Filter Criteria Parameter?
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!!! |
#2
|
|||
|
|||
You need to specify the criteria on your table2's
PropertyID field similar to the following: In (Select Distinct PropertyID From table1) HTH -----Original Message----- 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!!! . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Advanced Filter - Show All doesn't work | Marcotte A | Worksheet Functions | 2 | August 20th, 2004 06:27 PM |
Inverting an advanced filter | Kevin Lucas | General Discussion | 3 | June 16th, 2004 11:54 AM |
Please help! Displaying only rows with empty cells in a numeric field using Advanced Filter. Thanks | JOCA | New Users | 1 | June 5th, 2004 02:37 AM |
Advanced Filter List Range from within a Macro | Debra Dalgleish | Worksheet Functions | 2 | May 7th, 2004 12:26 AM |
Advanced Filter Using AND | keyt | Worksheet Functions | 1 | October 1st, 2003 06:50 PM |