Query Question - how to...

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

Guest

Hi - I am using Access 2003 -

I have two client databases which are suppose to be identical except 46
clients were not placed on one of them. I wanted to see if there was a query
which would compare both lists and only bring out the 46 from the bigger list
so I can add them to the smaller one so both will match once again.

Not as good as I used to be with Access so if I could have instructions on
how tod this, I would really really appreciate it.

Thanks, Anna
 
A simple way----go the the Find Unmatched query wizard (under
queries-new)---and then create and append query if all fields are the exact
same.
 
Anna said:
Hi - I am using Access 2003 -

I have two client databases which are suppose to be identical except 46
clients were not placed on one of them. I wanted to see if there was a query
which would compare both lists and only bring out the 46 from the bigger list
so I can add them to the smaller one so both will match once again.

Not as good as I used to be with Access so if I could have instructions on
how tod this, I would really really appreciate it.

Thanks, Anna
Click to expand...

The unmatched query wiz was mentioned (IIRC it was suggested to you
elsewhere as well), but now I wonder... if you know one table is a super
set of the other, why not just copy the all inclusive table from here to
there?
 
Back
Top