Data Entry Compare program -
10-02-2003
, 10:16 AM
I need to create a database that will do a check for data entry. Data
are entered 2x, by two different research assistants and I want to
compare their data entry to make sure each data point was entered
correctly.
I imagine that I need to somehow create a querry where it subtracts
cell A1, Database1 from cell A1,Database2. Anything that does not
result in a zero would indicate a discrepency. I would then want to
create a report that would show me the the discrepencies.
For example:
Item Database1 Database2
1 3 3
2 2 1*
3 1 1
4 2 2
Is this possible? Can the querry I described be done?
thanks,
marc |