Posted by gwhite1 on 05/03/07 00:04

I have a table with:

Name, Qtr, Amount
Tom, 1, 100
Bob, 1, 123
Tom, 2, 234
Bob, 2, 456
Steve, 1, 565
Steve, 2, 898

I want the query to return:

Name, Qtr 1 Amount, Qtr 2 Amount
Bob 123 456
Steve 565 898
Tom 100 234

I can't seem to figure this out! Any help would be appreciated!!
Sheila

• Next in forum: Re: Displaying Data Across when data goes down! Has to be easy!
• Prev in forum: Re: Need to tune a table for performance gains
• Thread view: Displaying Data Across when data goes down! Has to be easy!

[Reply to this message]