Getting a percentage from a text count

[ScottBeatty]

Hey everyone, I have a query that has clients sorted in the row area and a column from my table that is set up as text but only has yes/no options for the data. I have a pivot table that counts the yes's and counts the no's and finds a grand total; however, I want to be able to find the percentage of pass's given the grand total. I'm able to do this in Excel and was wondering if it was possible in Access. If anybody could help with this or has a suggestion about a better way to set up my query, feel free to shoot me a reply. Thanks a lot!

-Scott

 

[ypma]

Scott, i have created a demo for pass and fail , and hope i have understood your requirement.
Regards

 

[ypma]

Scott , Was my demo what you required ?