计算以毫秒为单位的访问百分比 [英] calculating percentage in ms access

问题描述

好人.我有两个子查询.它们如下

Hey good people. i have two subqueries.they are as follows

1- count of total houses = 5
2- count of houses with TV = 3

现在我要计算带电视的房屋的百分比，这是我正在使用的表达式

Now i want to calculate the percentage of houses with TVs, here is expression am using

% Houses with TV: 100/[totalhousesswithTV].[countofhouseid]*[totalhouses].[countofhouseid]

得到错误的结果，得到166.66666667，而不是60.表达式

am getting a wrong result, am getting 166.66666667, instead of 60. whats wrong with the expression

推荐答案

怎么了?这是由 ^ ]尝试改用:

This is caused by the Order of operations[^] try using instead:

% Houses with TV: 100/([totalhousesswithTV].[countofhouseid]*[totalhouses].[countofhouseid])

或

% Houses with TV: [totalhousesswithTV].[countofhouseid]/[totalhouses].[countofhouseid]*100

这篇关于计算以毫秒为单位的访问百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！