W
Whits End
I have an Access 97 database that has sample measurements for urchin sizes.
We manually input all values into one table for each validation ID. For each
validation ID there may be several tote# and also lots of measurement values
for each tote. These are written down manually on sampling sheets in the
plant. Once the initial input is put into the database we then do a
verification of the first input by typing in the same values in the same
order into another table. We then manually run a query to compare the two
tables for discrepancies.
What I would like to happen is that when inputting the values for
verification the second time, a message would come up immediately to inform
of any discrepancy in the tote# and in the measurement value for each line of
input. Also at the same time the program would give the option to keep the
value that is correct. If the first value typed in at the initial input
stage is incorrect but the verification value typed in is correct, I want the
option to replace the first table with the correct value. At the end of the
verification input for each validation ID I need all the values in the
verification table to be cleared so that the next validation ID values can be
verified with the same process. HELP.....
We manually input all values into one table for each validation ID. For each
validation ID there may be several tote# and also lots of measurement values
for each tote. These are written down manually on sampling sheets in the
plant. Once the initial input is put into the database we then do a
verification of the first input by typing in the same values in the same
order into another table. We then manually run a query to compare the two
tables for discrepancies.
What I would like to happen is that when inputting the values for
verification the second time, a message would come up immediately to inform
of any discrepancy in the tote# and in the measurement value for each line of
input. Also at the same time the program would give the option to keep the
value that is correct. If the first value typed in at the initial input
stage is incorrect but the verification value typed in is correct, I want the
option to replace the first table with the correct value. At the end of the
verification input for each validation ID I need all the values in the
verification table to be cleared so that the next validation ID values can be
verified with the same process. HELP.....