Double Entry

[daylilies]

Please Help. My boss would like me to create a database to enter survey results. He would like the database to be set up so one person enters the data. When completed, another person double enters the data and if the record does not match an error will come up. He says this can be done in Access. Does anybody know how?

Thank You in advance for any help.

-Erica

 

[CarpalT]

There are probably other ways to do this but...If you had them each enter the data into a separate table you could then run an "Unmatched" query to find records that were not identical between the two tables. To use it over you would have to clear the tables out between uses, either by running a delete query if you didn't need the data, or perhaps first appending it to a different table if you did.

You can trigger the "Unmatched Query Wizard" by clicking the "New" button in the query objects window.

Hope that helps.

 

[johnnymac43]

Hi Erica,

Alternatively, if each survey result has a unique identifier, eg. respondent ID plus question number, you could try the following:

> Have all data entered into the same table, with each of a pair having a unique ID (autonumber) and including the ID of the person who entered it.

> Run a grouping query on all fields except the autonumber and the user ID.

> Report any where the count of a group is 1 instead of 2.

To get back to a single occurrence of each correct entry, make a new table containing the first of each group of 2, and including the user ID from that record. If you want the second user ID you could link on respondent ID plus question number and run an update query.

HTH

John