devxlogo

Losing Decimal Places While Updating a Column

Losing Decimal Places While Updating a Column

Question:
I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query:

 update bakset distance = 1/trigwhere trig  NULL

it executes and gives the correct number, only without the decimal places. For example, one value of trig is 0.229. The value I want is 4.3668… (etc.), but the query only returns “4”.

Is there something I’m missing here? I’m using Access and the datatypes for both are number, double length. The trig values are correct, but they’ve never had any arithmetic operation performed on them before.

Answer:
Although I’m not familiar with Access, it sounds like an integer data type has crept into the mix somewhere, causing the rounding you are seeing.

The only suggestion I can make is to check the datatypes carefully and make sure that if they are numeric, that you have left enough precision in the declaration to hold all the decimal places you will want in your results.

Remember that an operation on your data could produce a number with more decimal places than you may be able to show.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist