[RESOLVED] MS Access 97 Database Decimal Problem

[khandu]

Hi

Ive created a DB for VB6

Now a field cost has the following

field size : long integer
format : general integer
decimal places : 2

Now whatever value is being put there.. its getting rounded off..

I want it to be stored as 2 decimal places..

So eg : I want the field to store number as 33.67 OR 99.01 .. or 99.00

But it is rounding it off..

can anyone tell me why is it rounding off and how to fix the field on any input to 2 decimal places..

[default user]

There is no problem aside from operator error; Its an integer field, look it up, then use single.

[khandu]

thanks .. rep added and thread resolved

[khandu]

oops sorry not resolved..

i am doing some calculations and saving in the field "cost"

still saving as 87.65002

Field Properties
datatype : number
field size : single
decimal places : 2

please help here

[default user]

Try trimming the value before saving.

val = int(Val * 100)/100

I suspect the format you are setting is for the Access user interface -input only.

[khandu]

yeah that trim did the works..