Member Avatar for locsin

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

  • 2 Contributors
  • 2 Replies
  • 104 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by locsin
Member Avatar for debasisdas

What is the data type you are using in Access . Try using decimal .

Member Avatar for locsin

Thank you it's working

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.