有没有办法在查询中计算％？ [英] Is there a way to calculate % in a query?

问题描述

我有两个问题。一个是回答我关于电话号码的问题，另一个回答我的问题访问次数。这两个查询都给了我一个关于财政季度的电话和访问次数的总计列。


现在我的问题是：是否可以使用％创建新查询？从这两个查询中得到结果？

I have two queries. One is answer my question as to the number of calls and the other one answer to my question number of visits. Both of these queries give me a TOTAL column of the number of calls and visits with respect to the Fiscal Quarters.


Now my question is: Is it possible to create a new query with %? Taking the results from those two queries?

推荐答案

是的。您可以在会计年度之前加入两个查询，然后将一个数字除以您想要计算的百分比。

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.

这篇关于有没有办法在查询中计算％？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！