Hi, is this what you want to calculate

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 supplier

my table is called test, so put there your real table name