[AccessD] Compare two tables with a large number of fields

Attached is a small database illustrating 1 possible fix for this

tblJob1 and tblJob2 are the same excepting 2nd field in tblJob2

Run the query in the db to show the incorrect record.


--Andrew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
connie.kamrowski at dpi.nsw.gov.au
Sent: Wednesday, 27 September 2006 9:44 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Compare two tables with a large number of fields

Good morning everyone,

I have an interesting issue. A Database was created, and put into
operation, it had a bug in Citrix so it was removed converted and put
back up for testing. Chinese whispers caused data to be entered into
both copies of the Database Apparently the word test is ambiguous in
some way.

Anyway now I have two Databases, each with a job table which contains
the following fields

tblJob1.BuildID, tblJob1.AreaID, tblJob1.SubElementID, tblJob1.WorkID,
tblJob1.StandardID, tblJob1.Location, tblJob1.Description,
tblJob1.TradeID, tblJob1.Unit, tblJob1.Quantity, tblJob1.EstCost,
tblJob1.Frequency, tblJob1.StartYear, tblJob1.PriorityID, tblJob1.Done,
tblJob1.Approved, tblJob1.Comment, tblJob1.CloneJobID

I need to compare the two tables and pull out any records which do not
match (some may be due to edits in a particular column) so I can add all
the added records into a third database( a copy of the original as at
the day testing started).

I have tried using the unmatched query but it will only let me enter 10
fields for comparison, any ideas on how I can do this?

Regards,

Connie Kamrowski

Senior Software Support Analyst
Information Technology
NSW Department of Primary Industries
Orange

Ph: 02 6391 3250
Fax: 02 6391 3290
This message is intended for the addressee named and may contain
confidential information. If you are not the intended recipient, please
delete it and notify the sender. Views expressed in this message are
those of the individual sender, and are not necessarily the views of
their organisation.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message.