Hello Trevor,
Yes there is a need....
I get a file on week 1 of each month of test results.
I then get a second file on week 2 of the same month which has the
accumulated results for week 1 and week 2.
The week 1 results in the weeks 2 file could have changed, e.g. a test
value in a field or maybe they omitted a test result which was
originally in weeks 1 file.
Because results are sent to suppliers at the end of each week, I can't
so well send out the accumulative results if week 1 of weeks 2 file is
different than the first weeks 1 file.
I have a results table and a results_temp table.
1st weeks file is OK to import to the results table after some checking.
2nd weeks results file is imported into the "results_temp table",
compared against the "results" table and I then need to show the user
the differences so she can make a decision which is correct.
I hope this explains why...
P.S. Your website has been of great help on the past while.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!