Allen (and groupies),
Thank you so much for replying to my post. I was finally able to dig
to the bottom of this. The problem centered around scientific
notation. Before I knew what the problem was, there were some clues
that gave it away.
1) Example- The original value was .02348374123, and if I would re-key
in the value, well, heck, we don't really need that precision, so I'd
re-key it in as just ".02348", and then there would be no problem!
2) Only SOME values were a problem, I'd run my program, and watch the
trace, comparing what it THOUGHT it was pulling as the value from the
table, and what it really should have been. Many of them were just
fine!
SO IN THE END... I set the definition for MC (Material Cost) to
Field Data Type: Number
Field Size: Decimal
Format: General Number
Precisiooo: 18
Scale: 4
Decimal places: Auto.
Thank you so much Allen for replying, I really enjoy using your web
site, and having you around when I'm in a jam like this. You are a
great asset to the Access Community.
Three Cheers for Allen Browne!!
Sincerely,
-BrianDP