Posted by ZeldorBlat on 05/03/07 00:36

On May 2, 8:04 pm, gwhi...@kc.rr.com wrote:
> 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

Search this newsgroup for the word "crosstab."

• Next in forum: Re: Displaying Data Across when data goes down! Has to be easy!
• Prev in forum: Displaying Data Across when data goes down! Has to be easy!
• Thread view: Re: Displaying Data Across when data goes down! Has to be easy!

[Reply to this message]