how can I double entry my data to ensure accuracy?

  • Thread starter Thread starter amanda
  • Start date Start date
A

amanda

Hi
I'm afraid I am very new to using access and am on a bit of a steep learning
curve. Unfortunately my timescales are very tight so I'm hoping that someone
out there can help me.

I have to enter large amounts of numerical data into a data base (mostly its
timing data or scores on clinical tests) for my research. One of the
requirements is that I enter the data twice in order to ensure quality and
accuracy. Somebody mentioned at some point that this should be quite easy to
do in access but I have searched the help function and the discussion groups
and can't find any guidance on how to do this.

Can anyone help? I really appreicate it!
thanks in advance
Amanda
 
On Thu, 7 May 2009 03:28:01 -0700, amanda

One approach would be to add a field to your table: IsPrimaryEntry
YesNo. Then you enter two sets of records, one with IsPrimaryEntry set
to True, and the other with False.
Then you write a select query to compare the two sets.

-Tom.
Microsoft Access MVP
 
amanda,
Using the same process that many web sites use, to enter your
Password or Email twice for verification.
Given two text controls Entry1 and Entry2, and Entry2 must equal
Entry1...
Let the user enter data into Entry1 with no restricition.
Use the BerforeUpdate event of Entry2 compare the two values.

Private Sub Entry2_BeforeUpdate()
If Entry2 = Entry1 Then
Exit Sub
Else
MsgBox "UnMatched, please check entry." , VBOKOnly
Cancel = True
Entry2.Undo
End If
End Sub

Matching will allow the user to continue, mismatch will notify
the user, and clear Entry2 for another attempt.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Thanks very much to both of you for your helpful answers!
I will try this out but it certainly looks like the solution to my problem.

Amanda
 
Back
Top