Question concerning TOP X data retrieval

[Yazster]

Hi,

Need help with this one. I have a source table, which contains one percentage field per week. This data is broken down by month, and week number, one percentage per business class ( 2 digit code, over 100 of them )

For example,

Class=2A
Week 1 Jan = 100%
Week 2 Jan = 95%
Week 3 Jan = 80 %

class=2B
Week 1 Jan = 50%
Week 2 Jan = 60%
week 3 Jan = 70%

I want a report that shows the percentages, per class, for the last 8 business weeks, going from left to right.

IE:
CL Week 1 Jan Week 2 Jan Week 3 Jan and so on...

The database contains years of data, but I only want the last 8 weeks.

Any ideas?

Thanks,
Yazster