double entry for data verfication

[jacchops]

I have a database that needs the information entered in twice, once by me and
once by someone else, so that the information can be compared to check for
inconsistencies. Is there an easy way to compare the two tables or databases?
I currently have two tables set up in one database, and I have created
queries to compare each field of the two tables. There are many fields, and
this is very time consuming and confusing. Is there an easy way (maybe
through an add-on or third party program), to compare the two tables? I can
import the 2nd entry tables into a separate Access database if needed. (There
are actually multiple tables, and each has to have a companion for double
entry.)

 

[Jenny Council via AccessMonster.com]

If you're doing what I think you're doing - then that is the right way to
go about it. It will be time consuming to setup first time, then it will
work forever after.

Your query will contain one column for every field in the table.

Lets say your tables are t1 & t2 and they contain fields f1 f2 f3 etc.
The query will show the two tables linked by a one to one join - linked by
a common ID field (there needs to be a common id - not sure how you do this
for your data). The query will have fields qf1 qf2 qf3 etc.

The query expressions will be something like this for each column:
qf1: iif([t1].[f1]=[t2].[f1],[t1].[f1],"Error t1:"&[t1].[f1]&" t2:"&[t2].
[f1])

qf2: iif([t1].[f2]=[t2].[f2],[t1].[f2],"Error t1:"&[t1].[f2]&" t2:"&[t2].
[f2])

qf3: etc etc.

copy and paste does it.