I need a query that finds matching data between two dbs

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

Guest

I need a query that finds matching fields lastname, firstname and dob,
between two access databases names newdb1 and newdb2. Anyone out there know a
script or query that will work? Thanks Jack
 
Import the table from newdb2 into newdb1 (or vice versa). You can either
import the table or link it, whatever you prefer. From there you can use the
query builder.
HTH
 
Hi, Jack.

Try:

SELECT P.DOB, P.firstname, P.lastname
FROM [;DATABASE=C:\Data\newdb1.mdb].tblPersonel AS P INNER JOIN
[;DATABASE=C:\Data\newdb2.mdb].tblPersonel AS P1 ON
((P.lastname= P1.lastname) AND
(P.firstname = P1.firstname ) AND
(P.DOB = P1.DOB));

.. . . where tblPersonel is the name of the table in both databases,
C:\Data\newdb1.mdb is the path to the first database, and C:\Data\newdb2.mdb
is the path to the other database.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top