>I have a table as follows:
>
>
>NAME PLANID NOSHARES
>Russell 1 50
>Russell 4 45
>Mark 3 50
>Mark 2 100
>John 3 30
>Russell 1 70
>Mark 1 35
>Mark 2 20
>
>
>What I would like produced from an SQL Statement is :
>
>
>NAME PLANID 1 PLANID 2 PLANID 3 PLANID 4
>Russell 120 0 0 45
>Mark 35 120 50 0
>John 0 0 30 0
>
>
>Is this possible? If so, How?
>
>Thanks in advance for your help,
>Russell
What you require is a cross-tab query. Use the Cross tab Wizard to generate it. Its very easy.
Cheers
Sanjay Kapoor
Relatively speaking is a conversation with Einstein