Microsoft access SUM function round decimal number to Integer

最新推荐文章于 2024-03-04 16:44:53 发布

转载最新推荐文章于 2024-03-04 16:44:53 发布 · 396 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/yangbin990/archive/2009/05/12/1455135.html

本文描述了在Access数据库中使用聚合函数SUM时遇到的奇怪问题：当计算涉及小数时，文本框仅显示整数值。通过调整字段的数据类型从长整型到单精度浮点型解决了此问题，确保了正确的小数点显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Recently I met a strange problem. That tooks me a few hours to dig out the cause.

I has a textbox in a access form, the textbox value is SUM([price]), the price can be decimal number, but the textbox only display the integer. For example, the price is 1.1 and the other price 1.3. Then the textbox display me 2.

The field price is a calculated value which is ItemPrice * Discount / 100, ItemPrice and Discount are fields in physical table.

I found ItemPrice data type is Long Integer. I changed it to Single. Then textbox display correct value with decimal point.

So my summary is if do aggregation function to a calculated field, the aggregration function force return data type to longest data type among physical fields involved.

转载于:https://www.cnblogs.com/yangbin990/archive/2009/05/12/1455135.html