Select supplier, count(days) as all_records,; sum(Iif(days<=2,1,0)) as count_1_2,; sum(Iif(days<=2,1,0))/count(days)*100 as perc_1_2,; sum(Iif(Between(days, 3, 6),1,0)) as count_3_6,; sum(Iif(Between(days, 3, 6),1,0))/count(days)*100 as perc_3_6,; sum(Iif(days>=7,1,0)) as count_7_more,; sum(Iif(days>=7,1,0))/count(days)*100 as perc_7_more; from test group by suppliermy table is called test, so put there your real table name