
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-----