>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
It isn't clear to me how you want to calculate the percentage. Percentage of what?
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)