help with query

[Guest]

I have a table "PART" with the following info

PART1 JAN 10
PART1 FEB 20
PART2 JAN 50
PART3 FEB 5

I want the report to look like this...

JAN FEB
PART1 10 20
PART2 50
PART3 5

Any help is appreciated.

Thanks

 

[BrainlordMesomorph]

Look up "CrossTab Query" in Access help

 

[Guest]

Thanks much

-----Original Message-----
Look up "CrossTab Query" in Access help





.