I need to make a report based of a query.
In the query I have the following data:
EquipmentID
Model
Full Name
LocationDesc
WarExpDate
Purpose
BdgYear
Expenditure

The data looks like this
AB123TZ            
Latitude D520    
NA    
Pittsuburgh Lab  
10-18-2011
Replacement  
2011/2012  
$2,000.00

sometimes you will have the same equipment had expenditure is more than one
budget year.  Example:
A laptop has a service extension in 2008/2009 then is replaced in 2011/2012
What I would like is for the follwoing to happen.
Group based on Equipment ID
ID     Model   Name    Location    WarExp   Purpose      07/08  08/09  
09/10   10/11
A...   Lat...     NA       PIT Lab      1-1-09    Service Ext            
$450            
                                                             Replacement    
                         $2000
B...    Lat...    Sue       CON          1-1-10    Service Ext              
        $250
                                                              Replacement  
                         $2000

I just don't know how to get it so the Budget Year can be across the top
like this.