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

Recommended Answers

All 2 Replies

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

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.