Help with currency field

[Mike Busch]

I set up a Cost field to multiple by my quantity field to give me a total.
When I input the amout oc the cost, it appears with two descimal point, yet
once I go to the next record it rounds off to a whole number. Example, when I
type it $113.75 it will shwo up ar $114.00. Any help in changeing the field
properties to reflect that the COst does not round up. Thanks in advance.

 

[Vincent Johns]

I set up a Cost field to multiple by my quantity field to give me a total.
When I input the amout oc the cost, it appears with two descimal point, yet
once I go to the next record it rounds off to a whole number. Example, when I
type it $113.75 it will shwo up ar $114.00. Any help in changeing the field
properties to reflect that the COst does not round up. Thanks in advance.

What kind of field is it? Is it in a Table, or a Query, or a Form, or a
Report? How you set the properties is slightly different for different
fields.

Also, does it just look like a whole number, or is it actually stored
that way? You can determine that by multiplying it by 10 or 100 and
seeing if the fraction comes back. If it just LOOKS like a whole
number, change its format properties. If the fraction got lost, change
its data type to not be an integer.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Duane Hookom]

Check to make sure the field data type is single, double, decimal, or
currency. Integer and Long Integer will not store decimal values.

 

[Chris2]

I set up a Cost field to multiple by my quantity field to give me a total.
When I input the amout oc the cost, it appears with two descimal point, yet
once I go to the next record it rounds off to a whole number. Example, when I
type it $113.75 it will shwo up ar $114.00. Any help in changeing the field
properties to reflect that the COst does not round up. Thanks in

advance.

Mike Busch,

Can you please show your actual calculation formula and the actual
data being used in it?


Sincerely,

Chris O.