Hi
I have a table with 3 fields: Date, Supplier and Days ( number of days . Is it possible, in one select statement, to group the number of days by supplier, but as a percentage within a range, i.e:

Supplier Name    1-2 days    3-6 days    7+ days
-------------
Supplier1          20%         30%          50%
Supplier2          35%         35%          30%

The date field is for the date range, and is in the where clause.

Thanks in advance,
Jaime