Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decimals

Status
Not open for further replies.

edgarchado

Technical User
Apr 5, 2005
59
AR
Hi to all,

I am adding numbers with decimals to a table using a form. The problem is that access keeps rounding up the the nearest full number. For example, if I imput 0,25 access saves 0, but if I input 0,51 it saves 1.

What should I do for access to save the exact number I enter??

Thanks.
 
In the table design change to

Field Size=Double
format = Currency/Fixed/Standard
Decimal Place=(As you required)

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.
 
Thanks for your reply. I can finally add decimals.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top