Venelina
This works great. Bravo!

Jaime

>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