Re: Query

On Sep 15, 8:41�am, Carlos <miotromailcar..._at_netscape.net> wrote:
> On 15 sep, 15:31, Mtek <m..._at_mtekusa.com> wrote:
>
>
>
>
>
> > Hi,
>
> > I was wondering if I can display data like this:
>
> > Original Data
> > 01-JUN-08 Type1 � � � � � Add � � � � � 4308
> > 01-JUN-08 Type1 � � � � � Delete � � � �4687
> > 01-OCT-08 Type2 � � � � � Delete � � � �5545
> > 01-OCT-08 Type2 � � � � � Add � � � � �11801
>
> > New Data
> > 01-JUN-08 Type1 � � �Add � �4308 � Delete � � 4687
> > 01-OCT-08 Type2 � � �Add � 11801 � Delete � � 5545
>
> > I want all related records on the same line......
>
> > Much thanks
>
> Google for 'PIVOT TABLE'
>
> HTH
>
> Cheers.
>
> Carlos.- Hide quoted text -
>
> - Show quoted text -

Pretty good Carlos. Do I need to code each value in the case statements? What if I do not know every value? Received on Mon Sep 15 2008 - 09:18:47 CDT