Finding records that don't match 
Author Message
 Finding records that don't match

I am trying to write code to go through two tables and find records
that are not the same.  I then want to write each of these records to
a new table for report generation and other fun stuff.  Is there an
easier way than to open the recordsets and step through the table one
at a time?  The fields should be the same, but one table may have more
or less fields than the other.  The fields that I am going to be
comparing will be the same type and should be the same.  All records
have a common indentifier.  I would love to be able to write a query
that does this, but don't know SQL enough...I think.  Any help would
be greatly appreciated.

Rick
----
Rick Huebner  NREMT-P, BS

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 4.5

mQBtAzOTR2YAAAEDALDmEKOydU7Z3bKhGrrRxvQ3QrEdnSwcTH8e17EqxiI4PpiT
3A8r1c8OvjsqN/8PMNc0R/ScbeYeYMKAKCLJggpT7cfGlNZG8tdLJjfB34S+1YJz
t4e5twfREh2O8FwGEQAFEbQgUmljayBIdWVibmVyIDxSaWNrSEBCaWdmb290LmNv
bT4=
=ARAU
-----END PGP PUBLIC KEY BLOCK-----



Thu, 26 Oct 2000 03:00:00 GMT  
 Finding records that don't match

Rick

Use the find Unmatched Query Wizard. Query tab in the database window, New,
Find Unmatched Wizard and then follow your nose

--
Terry
I'm not perfect, I wish I was. If you spot any errors please post so that I
may learn as well as others.

Check out Access FAQ's at
http://home.att.net/~dashish or
http://www.hammerdata.com/Newsgrp/



Quote:
> I am trying to write code to go through two tables and find records
> that are not the same.  I then want to write each of these records to
> a new table for report generation and other fun stuff.  Is there an
> easier way than to open the recordsets and step through the table one
> at a time?  The fields should be the same, but one table may have more
> or less fields than the other.  The fields that I am going to be
> comparing will be the same type and should be the same.  All records
> have a common indentifier.  I would love to be able to write a query
> that does this, but don't know SQL enough...I think.  Any help would
> be greatly appreciated.

> Rick
> ----
> Rick Huebner  NREMT-P, BS

> -----BEGIN PGP PUBLIC KEY BLOCK-----
> Version: 4.5

> mQBtAzOTR2YAAAEDALDmEKOydU7Z3bKhGrrRxvQ3QrEdnSwcTH8e17EqxiI4PpiT
> 3A8r1c8OvjsqN/8PMNc0R/ScbeYeYMKAKCLJggpT7cfGlNZG8tdLJjfB34S+1YJz
> t4e5twfREh2O8FwGEQAFEbQgUmljayBIdWVibmVyIDxSaWNrSEBCaWdmb290LmNv
> bT4=
> =ARAU
> -----END PGP PUBLIC KEY BLOCK-----



Thu, 26 Oct 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB%: Finding matching records in a Record set...

2. Object Types don't match message

3. Names don't match posts

4. SDK, components, and actual devices don't match up

5. how do I - find out how many records match abc and how many macth xyz

6. My projects containg toolbars don't appear Can't find COMCTL32.ocx

7. Seek Nearest Match if exact match not found ?

8. Seek Nearest Match if exact match not found ?

9. Seek sometimes doesn't match record

10. Records locks don't release - error 3260/3187

11. Wheel Mouse Scrolling Records When I Don't Want It To

12. DataGrid, don't want the last row (new record), how to remove

 

 
Powered by phpBB® Forum Software