Can I query one table based on another table

[psptpr98]

I am looking to make a query that I can store all the items I am searching for in one table and then run it against another for matching items. Any help would be great.

fb

 

[jrbarnett]

You can use an ordinary inner join query to list the matching records, or the "Find Unmatched" query wizard to find records in the target table that don't match.

You will need to do a custom install of MS Office or Access and install the advanced wizards to install this if it is not available on your setup.

John

 

[psptpr98]

That was just to easy, I really should have known that. thanks again.

 

[psptpr98]

OK I ran into a small problem with this. It will only search for matches on the first field in the join table, how can I force it to look for matches on more than one field from the joined table?

 

[jrbarnett]

Go into query design mode and drag joins between multiple fields in the two tables. You will see multiple black lines between the tables.
Right click on the join to choose the appropriate join type.

John