dbTalk Databases Forums  

Data Entry Compare program

comp.database.ms-access comp.database.ms-access


Discuss Data Entry Compare program in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marc
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.