Calculate Percentage based on previous column

[VictoriaAlbert]

This is what the table looks like:



Enrolled ID#
Yes 118
No 234
No 312
Maybe 513

And I want to create a query that gives in column A the unique entries of the first column (Enrolled), column B the count of each entry, and column C the percentage that that count represents.

So, the query result would look like
Yes 1 25%
No 2 50%
Maybe 1 25%

I have written column A and column B of the query, where column A is Field: Enrolled and Total: Group By, where column B is Field: ID# and Total: Count.

I'm stumped on how to write the expression for column C. Any help would be greatly appreciated.

[apr pillai]

Use the Query as Source for another Query and write the following expression in a new Column:

PRCNT:[ColumnB]/DSUM("ColumnB","QueryName")

Highlight the PRCNT column, display it's Property sheet and set the format property value to percent.