comparing tables

[Colleen Loos]

I want to validate my questionnaire data by having it
double entered. Is there a simple way to compare two
records in separate tables (or even two complete tables)
to check if the data matches in every field?

 

[Ayelet]

Hi,
I'm not sure this is the best design, but if you're sure
about the two tables thing, You can create a query, and
have it display all the records where the fields are not
equal.make a 1-1 relationship between the table, at the
primary key field. place both tables in the query design
grid, make sure the link between them says "show only
records where both fields are equal". for each field you
want to compare, put the field from one table in the
fields raw, and in the criteria raw place "<> [OtherTable].
[FieldName]". syntax migth need some work, but that's the
general idia. Use Or between the different fields (-->
each criteria in a seperate line), so youll see all the
records where at least one of the fields is different.

Good Luck,
HTH,
Ayelet