Ill try to give a little background on this to make it easier to understand. I've had a on going project for some 7 months. The project consists of taking forms that have barcodes and scanning those forms in. We take the Persons ID field [EID] and note their election; they only have 2 choices Continue or Convert [CHOICE].
Originally the person heading up the project decided to use a barcode wand and we found there to be many discrepancies on the recorded elections. I have had the forms rescanned using an automatic method that calculated properly. I now need to go back and compare the results.
So (whew) I have 2 tables GR2 and PPR both contain the same fields [EID] and [CHOICE]. The PPR contains the automatic scans whereas GR2 has the manual barcode wand. I would like to compare the [CHOICE] fields in each and find the errors. Also compare the [EID] fields and find out if we missed any. I've tried several methods by searching in this forum, but have not had any success with this. Can anyone lend a hand, or point me in the right direction? TIA!!
Originally the person heading up the project decided to use a barcode wand and we found there to be many discrepancies on the recorded elections. I have had the forms rescanned using an automatic method that calculated properly. I now need to go back and compare the results.
So (whew) I have 2 tables GR2 and PPR both contain the same fields [EID] and [CHOICE]. The PPR contains the automatic scans whereas GR2 has the manual barcode wand. I would like to compare the [CHOICE] fields in each and find the errors. Also compare the [EID] fields and find out if we missed any. I've tried several methods by searching in this forum, but have not had any success with this. Can anyone lend a hand, or point me in the right direction? TIA!!
