Access Querries for Count and Percentage

[addis123]

Here what my table looks like. I want to a query to calculate the percentage of Overdue tasks over all tasks . Second if possible, I want to calculate the percentage of each overdue task over the overdue total.

 

[addis123]

Here what my table looks like. I want to a query to calculate the percentage of Overdue tasks over all tasks . Second if possible, I want to calculate the percentage of each overdue task over the overdue total. Table has these columns: Task ID, Task Name, and Task Status. Under Task Status I have records like ontime, overdue, warning. NB. my query is about the overdue task status. I have about 150k task names.They can be grouped.

 

[addis123]

basically here is what I want: Number of Overdue/Total number of Overdue formatted in percentage. and Number of Overdue/Total of Task Status in percentage