943,632 Members | Top Members by Rank

Ad:
Mar 18th, 2008
0

Rounding numbers problem

Expand Post »
hi

I designed simple program of computing the petrol bill and save it into MSACCESS data base. This bill included decimal places. But everytime I check my msaccess database. The number is automatically rounding up or down. I try to set standard settings with two decimal places but the number still rounding automatically.

Anybody know how to save the numbers in MSACCESS DATABASE without automatically rounding.

ex.
if the value of number is 23.25 the same value in my access database field is also 23.25.

thanks in advance
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
locsin is offline Offline
47 posts
since Aug 2007
Mar 18th, 2008
0

Re: Rounding numbers problem

What is the data type you are using in Access . Try using decimal .
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007
Mar 18th, 2008
0

Re: Rounding numbers problem

Thank you it's working
Reputation Points: 10
Solved Threads: 0
Light Poster
locsin is offline Offline
47 posts
since Aug 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Get StartUp Folder
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Data report printing





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC