Query Question

[Roy Harrell]

Suppose I have a simple table as follows:

PartName	Tolerance	Cycles
A		1		10
A		2		11
A		3		13
A		4		15
A		5		18
B		1		12
B		2		14
B		3		16
B		4		16
B		5		17
C		1		6
C		2		7	
C		3		7
C		4		8
C		5		10


How do I set up a query whose output would 
look like this:

Tolerance	PartA	PartB	PartC
1		10	12	6
2		11	14	7
3		13	16	7
4		15	16	8
5		18	17	10


Thanks,

Roy Harrell
Adaptive Equipment
352.372.7821