Subject | help on query |
---|---|
Author | Sudheer Palaparambil |
Post date | 2003-07-29T04:37:56Z |
Hi,
I have a few records in a table like this
Code entry_date value
---- ---------- -------
01 01.01.2003 200.00
01 15.01.2003 1200.00
02 30.01.2003 500.00
02 08.02.2003 100.00
01 15.02.2003 300.00
02 04.03.2003 200.00
01 01.03.2003 1000.00
02 11.03.2003 500.00
and I want to generate a report like this in
FB 1.5.
Code January February March
-----------------------------------------------
01 1400.00 300.00 1000.00
02 500.00 100.00 700.00
Please help
Thank You.
Sudheer
__________________________________________________
Yahoo! Plus - For a better Internet experience
http://uk.promotions.yahoo.com/yplus/yoffer.html
I have a few records in a table like this
Code entry_date value
---- ---------- -------
01 01.01.2003 200.00
01 15.01.2003 1200.00
02 30.01.2003 500.00
02 08.02.2003 100.00
01 15.02.2003 300.00
02 04.03.2003 200.00
01 01.03.2003 1000.00
02 11.03.2003 500.00
and I want to generate a report like this in
FB 1.5.
Code January February March
-----------------------------------------------
01 1400.00 300.00 1000.00
02 500.00 100.00 700.00
Please help
Thank You.
Sudheer
__________________________________________________
Yahoo! Plus - For a better Internet experience
http://uk.promotions.yahoo.com/yplus/yoffer.html