rounding numbers

[Joe Henry]

Hi, I have designed a database in access with office xp. I want to enter
numbers in the form I have created with one decimal point. My problem is, it
keeps rounding down to the whole number. I don't want to use the currency
field type, as I don't want the dollar sign. Is there any solution?

Thanks

 

[Cheryl Fischer]

You can change the FieldSize of your number field to Double or Single.

hth,

 

[Joe Henry]

thanks, worked great !!!

You can change the FieldSize of your number field to Double or Single.

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


is,