MS Access 2002 on Windows XP...

I've been assigned to a database where data-entry is done
twice, and then it is to be "cross-checked" for data that
doesn't match, indicating probable data-entry errors.

Is this even possible? It seems to me that there has to be
some unique-data field that can be used to "align" the two
data-entry tables, then check the rest of the fields.

But even that strategy has me fumbling. If a given field in
tbla has data entered, but it got skipped in tblb, it's
difficult to compare between the two (nulls don't compare).

The goal would be to have a form that will find each
mis-matched pair and display the two records one above the
other, so that a visual glance will easily pick up any
fields that don't match, and the data can be edited right
there. But using any "IIf" statements in the queries
feeding the form cause a non-updatable recordset. Some of
the fields are text fields, and I can get around the problem
by making the default value a zero-length string, which
compares easily. But other fields are numeric, and I can't
figure out how to compare these fields and still come up
with an updatable recordset.

Comments welcome!

--
croy

On Dec 22, 12:56*pm, croy <c... (AT) invalid (DOT) net> wrote:
I would look at the query builder. Learn to design queries. Look in
help on how to create totals queries, using the Distinct clause found
in the property sheet of the query builder, and how to create
expressions in the query builder.