D
Don
I know you can run a "find unmatched query" that creates a query that finds
records in one table that have no related records in another table, but what
about a query that can find records where the field values have changed or
are different. For example, say I have two identical tables with ten
records, and the values of the primary key of the ten records are the same
between the two tables, but some of the other field values are different
(for example 4 records). How can I run a query to find those four records? I
am trying to compare a table that is constantly updated, with the same table
as it was say a month ago, or year ago. Hopefully I didn't sound too
confusing. Any help is greatly appreciated. Thanks, Don
records in one table that have no related records in another table, but what
about a query that can find records where the field values have changed or
are different. For example, say I have two identical tables with ten
records, and the values of the primary key of the ten records are the same
between the two tables, but some of the other field values are different
(for example 4 records). How can I run a query to find those four records? I
am trying to compare a table that is constantly updated, with the same table
as it was say a month ago, or year ago. Hopefully I didn't sound too
confusing. Any help is greatly appreciated. Thanks, Don