Microsoft Access - calculating percentage from two subqueries
Asked By michael brown on 11-Aug-12 04:38 PM
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/[totalhouseswithTV].[countofhouseid]*[totalhouses].[countofhouseid]
am getting a wrong result, am getting 166.66666667, instead of 60. whats wrong with the expression