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