Extract records from query

[Robin]

Hi

I have 2 queries, Query1 and Query2. Both have common ID field. I create a
new query for the Query1 and Query2 and link the ID field of both queries.
My new query has all the fields which both quries have same ID. My problem
is how can I extract those records from Query2 which ID does not match the
ID in Query1. I tried using Recordset and insert individual records, but its
time consuming. One important factor is the database is very huge, it takes
1 to 2 hours to complete the job. Please help. Thanks.


Regards
Robin

 

[Gary Miller]

Robin,

How large is it? My eyebrows raise at 1 to 2 hours.

The query you describe sounds like it should be able to be
performed directly on the tables instead of bringing in two
more queries into the picture. May I assume that your ID
fields are both primary keys? If not, this will slow things
down. They need to be indexed at the least.

There is a Query Wizard that will create a 'Find Unmatched
Records' query that will do just what you are looking for.
Go to Queries and New and seled Find Unmatched.

By the way, you do have the ability in Access to do a bit of
renaming of your queries and everything else. Give them a
name that means something to everyone.

Gary Miller