--- Joe Conway <[EMAIL PROTECTED]> wrote:
> George McQuade wrote:
> > date tran glamt
> > 08/20/03 1001 3010 -30.00
> > 08/20/03 1001 1030 -300.00
> > 08/20/03 1001 1060 +330.00
> > 08/20/03 1002 ...next transaction
> > ...
> > an
Hello everyone,
I have a table that looks like:
date tran glamt
08/20/03 1001 3010 -30.00
08/20/03 1001 1030 -300.00
08/20/03 1001 1060 +330.00
08/20/03 1002 ...next transaction
...
and I need to convert to:
date glcr gldb amt
08/20/03 1060 3010 30.00
08/20/03 1060 1030 300.0