在交叉表查询中删除零 [英] Dropping Zeros in a crosstab query

问题描述

我在表单上有一个列表框，它使用我的交叉表查询来显示查询结果。对于显示数字的字段，将删除最后一位数为零的数字。示例$ 88.80显示为$ 88.8。我将字段设置为数字/双精度。有趣的是原始数据文件最后有零。我想我需要解决查询本身的格式化问题。


有没有人有任何想法？

解决方案

88.80显示为

88.8。我将字段设置为数字/双精度。有趣的是原始数据文件最后有零。我想我需要解决查询本身的格式化问题。


有没有人有想法？

我在表单上有一个列表框我的交叉表查询显示查询结果。对于显示数字的字段，将删除最后一位数为零的数字。实施例

I have a listbox on a form that uses my crosstab query to display the query results. For the fields that display numbers, the numbers with a zero in the last digit are being dropped. Example $88.80 is displayes as $88.8. I have the field set as a numeric/double. The interesting thing is that the raw data file has the zeros on the end. I am thinking I need to resolve the formating issue in the query itself.

Does anybody have any ideas?

解决方案

88.80 is displayes as

88.8. I have the field set as a numeric/double. The interesting thing is that the raw data file has the zeros on the end. I am thinking I need to resolve the formating issue in the query itself.

Does anybody have any ideas?

I have a listbox on a form that uses my crosstab query to display the query results. For the fields that display numbers, the numbers with a zero in the last digit are being dropped. Example

这篇关于在交叉表查询中删除零的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！