"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.