Compare groups of records to large table

[amerifax]

I would like to query a table called permit which has a field called seal. Seal is a seven character field. Permit has approximately 300,000 records. My problem is I have stacks of records that may or may not be in the permit table. My goal is to run 10 to 30 records against the permit table looking to see if any of the 10 to 30 records exist within the permit table.

So basically I have a bunch of records that only contained the field "Seal". If one of the 10 to 30 records exist in the permit table there should be an indicator next to those 10 to 30 records showing it exist.

Now for my problem. I don't have a clue to how this should work. This novice, or greenhorn, is hoping to find ways that this can be accomplished. I'm dealing with approximately 4,000 records that need to be compared to the "Permit" table. And usually I'm trying to compare anywhere from 5 to 30 records at a time.

Bob

 

[Alansidman]

Bob, if you go to create a query, click on the wizard and follow the instructions for unmatched queries it should guide you through the procedure for what you need.

 

[amerifax]

Will this wizard show me a query of one record at a time or will I be able to enter many values and then do the query?
Bob

 

[Alansidman]

It will give you the results of all records in one table that have no match in the other table.