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