Report...Not sure if this can be done.

M

Michelle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Applications won't start. Dr Watson Symbol file could not be found 5
FS LARGE FORMAT scanners , INKJET printers , inkjet plotters (hp designjet) , 11x17 color laser $199 0
FS inkjet plotters AND continous feed 36 inch scanners 0
FS epson receipt printer $99 , seiko label printers $49 symbol barcode guns $75 intermec wireless ba 0
FS PRINTER PARTS trays fusers drums printheads -- oki fujitsu hp genicom epson ibm dec jetdirect las 0
FS PRINTER PARTS trays fusers drums printheads -- oki fujitsu hp genicom epson ibm dec jetdirect las 3
HP color laser $299 includes jetdirect ethernet card - extra toners NEW $20, also hp 8500 $700 8550n 1
FS PRINTER PARTS trays fusers drums printheads -- oki fujitsu hp genicom epson ibm dec jetdirect las 1

Top