且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

有没有办法在查询中计算%?

更新时间:2022-06-12 23:56:43

是的。您可以在会计年度之前加入两个查询,然后将一个数字除以您想要计算的百分比。
Yes. You can join the two queries by the fiscal year and then divide one number by the other for whatever percent you''re trying to calculate.


感谢Rabbit。

我似乎无法加入两个查询,因为查询向导只允许我在创建新查询时选择一个查询。
Thanks Rabbit.
I can''t seem to join two queries because the query wizard only me to choose One query when creating a new one.


请记住,百分比存储为简单分数,所以要小心您了解50%== 0.5和50%= / = 50.显示的数字格式与实际值无关。
Remember, percentages are stored as simple fractions, so be careful you understand that 50% == 0.5 and 50% =/= 50. The format of the number displayed has no bearing on the actual value itself.