Report Help.

[Nosbod]

Hi,

I have a query which shows customers and their relevant annual spend.

[CustName] [Spend2012] [Spend2011] [Spend2010] [Spend2009]
CustA 10 30 30 10
CustB 20 10 20 20
CustC 30 20 10 30

I would like a report which shows the information as a "ranked" display based on their spend for that particular year as follows:-

Rank [2012] [2011] [2010] [2009]
1st CustC CustA CustA CustC
2nd CustB CustC CustB CustB
3rd CustA CustB CustC CustA

I'm unsure on the best way to tackle it so any pointers would be much appreciated.
Apologies in advance for the explanation method but i couldn't think of an easier way.

Chris.

 

[Nosbod]

Having no replies I now wonder if this too hard to achieve in Access or is it because of the poor explanation?

Chris.