Rounding numbers problem

Thread Solved

Join Date: Aug 2007
Posts: 47
Reputation: locsin is an unknown quantity at this point 
Solved Threads: 0
locsin locsin is offline Offline
Light Poster

Rounding numbers problem

 
0
  #1
Mar 18th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Feb 2007
Posts: 2,093
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 126
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: Rounding numbers problem

 
0
  #2
Mar 18th, 2008
What is the data type you are using in Access . Try using decimal .
Share your Knowledge.
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 47
Reputation: locsin is an unknown quantity at this point 
Solved Threads: 0
locsin locsin is offline Offline
Light Poster

Re: Rounding numbers problem

 
0
  #3
Mar 18th, 2008
Thank you it's working
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC