Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: How do I check for errors in a dataset that was double-entered

Discussion in 'Information Technology' started by Helen, Jul 28, 2006.

  1. Helen

    Helen
    Expand Collapse
    Guest

    "Joseph Meehan" wrote:

    > Marcia Castro wrote:
    > >I am working with data that have been entered twice for checking
    > > purposes (quality control). Now I need to check if these two datasets
    > > are identical, or if there are differences that need to be checked
    > > for mistakes.
    > > EpiInfo has such a feature, however it cannot handle large datasets.
    > > How can I do this verification in Access?

    >
    > How are the entries store?
    >
    > How consistent is the recorded data?
    >
    > I prefer to do the checking as the data is entered. I don't have any
    > code for this handy, and I did not find any doing a quick search, but I
    > suspect there is something out there. Hopefully someone will offer a
    > reference.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit


    I also have the same problem. All the entries are either numbers(1,2,3...)
    or text(eg. 001, 002...). Both tables format is the same. Just asked 2 people
    to enter the same information independently.

    Previously, I linked the 2 tables by 1 primary key. Then use queries to show
    those with different entries for each variable. If I have many
    variables/questions, it took me a lot of time to complete this checking
    process.

    I know SPSS Data Entry software can do it. But I want to stick to Access
    (more user friendly). So I really want to find a faster way to do this in 1
    single process.
     
  2. Loading...


  3. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    If the fields are supposed to be identical then there isn't really any other
    way to check than to compare each field against it'scorresponding field in
    the other set.

    Something like

    SELECT *
    FROM table1
    INNER JOIN table2
    ON table1.keyfields = table2.keyfields
    WHERE
    table1.datafield1 <> table2.datafield1
    OR
    table1.datafield2 <> table2.datafield2
    OR
    table1.datafield3 <> table2.datafield3

    etc.

    or you could run a separate query for each pair of feilds.

    Personally I would check on data entry though and use th above mthod as a
    final check.

    Checking on data entry you simply open a recordset filtered to the correct
    record and thn check the value entered against the data entry as it occurs.


    --

    Terry Kreft


    "Helen" <Helen@discussions.microsoft.com> wrote in message
    news:2CAAF20C-6817-4CCD-8A46-DAB6495276CA@microsoft.com...
    > "Joseph Meehan" wrote:
    >
    > > Marcia Castro wrote:
    > > >I am working with data that have been entered twice for checking
    > > > purposes (quality control). Now I need to check if these two datasets
    > > > are identical, or if there are differences that need to be checked
    > > > for mistakes.
    > > > EpiInfo has such a feature, however it cannot handle large datasets.
    > > > How can I do this verification in Access?

    > >
    > > How are the entries store?
    > >
    > > How consistent is the recorded data?
    > >
    > > I prefer to do the checking as the data is entered. I don't have

    any
    > > code for this handy, and I did not find any doing a quick search, but I
    > > suspect there is something out there. Hopefully someone will offer a
    > > reference.
    > >
    > > --
    > > Joseph Meehan
    > >
    > > Dia duit

    >
    > I also have the same problem. All the entries are either numbers(1,2,3...)
    > or text(eg. 001, 002...). Both tables format is the same. Just asked 2

    people
    > to enter the same information independently.
    >
    > Previously, I linked the 2 tables by 1 primary key. Then use queries to

    show
    > those with different entries for each variable. If I have many
    > variables/questions, it took me a lot of time to complete this checking
    > process.
    >
    > I know SPSS Data Entry software can do it. But I want to stick to Access
    > (more user friendly). So I really want to find a faster way to do this in

    1
    > single process.
     

Share This Page