Grouping query with percentage

[msadiqrajani]

Hi,
I have below dataset.

Task Completed
------------------------
TaskA y
TaskB y
TaskC n
TaskA n
TaskB n
TaskA y
TaskC n


I need following output from dataset

Task Total Completion%
------------------------------------
TaskA 3 67%
TaskB 2 50%
TaskC 2 00%



I have figureout how to get Total but am unable to figure out how to get Completion percentage.

Please help me with query.
Thanks

[June7]

This would be easy to do in a report using Grouping & Sorting with aggregate calcs. The report would allow display of the detail records and summary calcs. Just set report RecordSource to the source data table/query and do summary calcs in report and group headers/footers. The percentage calc would be an expression in textbox of Task group header/footer that refers to Count calc textbox in report header/footer and Count calc textbox in group header/footer: [tbxGroupCount]/[tbxTotalCount]