Losing Decimal Places While Updating a Column

Losing Decimal Places While Updating a Column

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.

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.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several