Help with Calculate % (PLEASE HELP!!!!!!!!!!!!!!!)

[Chris]

Calculate %

I need some help with calculating the % --

This is what I have thus far --- I created a query and for one of the column
I did a ‘count’ Now I will like to add another column in my query and take
the column I did a count on and divided it by the total number of records in
the same column.

Is this possible


Thanks in advance

Chris

 

[Duane Hookom]

Are you trying to do this in a report?

 

[Chris]

No in a query

Are you trying to do this in a report?

 

[Duane Hookom]

You can use a subquery as the denominator in your expression. Something
like:

SELECT Dept, Gender, Count(*) as NumOf, Count(*)/(SELECT Count(*) FROM
tblEmployees) as PctOf
FROM tblEmployees
GROUP BY Dept, Gender;