matching tables

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

Guest

Help!!! I have only been working Access 2000 for a couple of months now and
have not been able to understand how to match information in two tables. Let
me explain….
Table One
ID Rating Com. Date
375 G 1/1/04
377 R 1/15/04
345 Y 1/19/04
333 Y 1/1/04

Table Two
ID Rating Com. Date
375 R 1/2/04
377 G 1/15/04
333 Y 1/1/04

What I need is a report that will tell me 375 dates do not match, 377
Ratings do not match and 345 is missing or has no matches . Can this be done
???and if so how????? Thank you in advance for any help.
 
Look in the help file for more info on "unmatched queries".

I would be interested to know why you have two tables with the same data,
though.

Rick B
 
Political Reasons see below
I have a table with information being generated from an Access form by
multiple outside users during the week and an Excel form being generated from
a secured data base being sent to me (and imported into Access) from on
internal source once a week. At the end of the day I need to know what was
updated in my Access database (the one being generated by the outside users)
so that I can update the internal database. I know this is a duplication of
work but the outside users do not have access to the internal database and I
my company will not allow access to outside users so I have to update the
internal database myself.
 
Hi Lisa.
If you create a query with the following sql it will work:
SELECT TableOne.ID, IIf([TableOne].[Rating]<>[TableTwo].[Rating],"Rating
does not match","") AS RatComp,
IIf([TableOne].[Com-Date]<>[TableTwo].[Com-Date],"Com-Date does not
match","") AS ComDateComp, IIf([TableTwo].[ID] Is Null,"No ID Match","") AS
IDComp
FROM TableOne LEFT JOIN TableTwo ON TableOne.ID = TableTwo.ID;
The SELECT line is all on one contnuous line and the FROM line is also all
on one line.
Hope this helps.
You may have to adjust some of the names I used.
Fons
 
Political Reasons see below
I have a table with information being generated from an Access form by
multiple outside users during the week and an Excel form being generated from
a secured data base being sent to me (and imported into Access) from on
internal source once a week. At the end of the day I need to know what was
updated in my Access database (the one being generated by the outside users)
so that I can update the internal database. I know this is a duplication of
work but the outside users do not have access to the internal database and I
my company will not allow access to outside users so I have to update the
internal database myself.
 
Fon


Fons Ponsioen said:
Hi Lisa.
If you create a query with the following sql it will work:
SELECT TableOne.ID, IIf([TableOne].[Rating]<>[TableTwo].[Rating],"Rating
does not match","") AS RatComp,
IIf([TableOne].[Com-Date]<>[TableTwo].[Com-Date],"Com-Date does not
match","") AS ComDateComp, IIf([TableTwo].[ID] Is Null,"No ID Match","") AS
IDComp
FROM TableOne LEFT JOIN TableTwo ON TableOne.ID = TableTwo.ID;
The SELECT line is all on one contnuous line and the FROM line is also all
on one line.
Hope this helps.
You may have to adjust some of the names I used.
Fons

Lisa said:
Help!!! I have only been working Access 2000 for a couple of months now and
have not been able to understand how to match information in two tables. Let
me explain….
Table One
ID Rating Com. Date
375 G 1/1/04
377 R 1/15/04
345 Y 1/19/04
333 Y 1/1/04

Table Two
ID Rating Com. Date
375 R 1/2/04
377 G 1/15/04
333 Y 1/1/04

What I need is a report that will tell me 375 dates do not match, 377
Ratings do not match and 345 is missing or has no matches . Can this be done
???and if so how????? Thank you in advance for any help.
Click to expand...
Click to expand...
 
Back
Top