| | |
|
|
|
Table comparisons |
|---|
| message from =?Utf-8?B?QW5keQ==?= on 18 May 2004 |
Need some help sifting through some data. I have one database with two tables (A and B). Both tables contain only one Field. Table A has 350,000 entries, and Table B containes 355,000 entries. 350,000 entries from both tables are the same, the other 5,000 are not. I need to find these 5,000 entries. Rather than having to manualing comparing line by line, is there a way to get a list of the 5,000 fields that are different. Thanks in advance for the assistance.
|
| John Vinson replied to =?Utf-8?B?QW5keQ==?= on 18 May 2004 |
Create a new Query, and use the "Unmatched Query Wizard" to build a
query that does exactly this.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| es replied to =?Utf-8?B?QW5keQ==?= on 18 May 2004 |
create a new query and use the wizard and the UnMatched
Query builder.
database with two tables (A and B). Both tables contain
only one Field. Table A has 350,000 entries, and Table B
containes 355,000 entries. 350,000 entries from both
tables are the same, the other 5,000 are not. I need to
find these 5,000 entries. Rather than having to manualing
comparing line by line, is there a way to get a list of
the 5,000 fields that are different. Thanks in advance for
the assistance.
|
| Lynn Trapp replied to =?Utf-8?B?QW5keQ==?= on 18 May 2004 |
You might try running the Unmatched Query Wizard
|
| =?Utf-8?B?QW5keQ==?= replied to Lynn Trapp on 18 May 2004 |
At the risk of sounding stupid, how do you create an Unmatched Query? I am using Access 2003 and i am unable to locate this Unmatched Query wizard that everyone seems to be mentioning. Thank for tolerating my stupidity.
|
| Lynn Trapp replied to =?Utf-8?B?QW5keQ==?= on 18 May 2004 |
In the Database Window, under Queries, click the New button. It should be in
the list of possible wizards.
|
| John Vinson replied to =?Utf-8?B?QW5keQ==?= on 18 May 2004 |
If the query wizard isn't installed (which can happen) you can create
your own. Create a Query joining Table1 to Table2 by the (only!? odd
table!) field. Change the Join type to Left Outer Join by clicking the
join line and choosing Option 2: "Show all records in Table1 and
matching records in Table2". Select the joining field from Table2 and
put a criterion on it of
IS NULL
The query will now show only those records in Table1 which do *not*
have a match in Table2.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Table comparisons (MS Access Database)
