For some reason,... starting at record # 91,885,
some of the records show "0" and some show "1".
I can see no pattern as to why this happened.
Think you've got a data consistency issue. Some numbers are text numbers,
some are real numbers. Try this to convert all data to real numbers. Copy a
blank cell, then select entire cols A and B, right-click paste special
Check "Add" OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark246" wrote in message
...
That sorta' works, Max. Almost. Thanks, but...
About 80% of the 140,000 records have the ID of 1557.
Starting at #24,643, ALL of the records after that have that ID #1557.
Records from #24,643 to 91,884 all indicate "0" in Column C, as they
should.
For some reason,... starting at record # 91,885,
some of the records show "0" and some show "1".
I can see no pattern as to why this happened.
Have ya' got an explanation?
Thanks.
Mark246