Numeric field is rounding up

[Brook]

I have a numeri field that is set for two decimal places.
However, when I enter a number 6.80, it rounds up to 7.00.

Does anyone have any ideas / suggestions?

Brook

 

[Guest]

Make sure that the numeric type is single, double, or currency depending on how large a number you need to hold. It sounds like you have it set to the default which is long integer. An integer is a whole number.

 

[John Vinson]

Bridge Players know all the Tricks

.... and the only thing worse than three bridge players who don't have
a fourth, is four bridge players who do have a fifth! <g>

Welcome to the newsgroups, Pat. Good answers... just don't trump your
partner's ace!