comparing tables

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

Does anyone out there know how I can compare two tables on
a daily basis for changes in any of 60 fields? We do
daily downloads from an online registration service, but
if our participants change a field on the record, we have
no idea what they have changed. If anyone can help, it
would be much appreciated.

Thank you
 
Access has a wizard for this, I think, but basically you create an outer
join (double-click the join line between the two tables in the query and
choose "All records from..."), and then select for the match being null.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Thanks for the responses, but I have more of a complicated
problem. I know that I can have the table updated with
the new information, but my meeting planners have to know
which field on which record was changed. For example,
they may need to know that a participant has changed their
arrival date for hotel reservation purposes. In this
case, I would need to identify that that particular
participant had a change and the "Arrival Date" field is
the only field out of 60+ fields that has changed. We
need to specifically identify that that field has
changed.

Any help would be appreciated...>-----Original Message-----
 
Yes, I understand that. Have you tried the unmatched join wizard? Match on
all fields and see what happens.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top