Ledger Code 1 "Scb Bank A/c" Opening Balance 145,000.00 ================================================================== AcCode Description Date DrAmt CrAmt 12 Xyz Customer 01/01/99 50,000.00 - 13 Claims 15/02/99 - 1560.00 Ledger Code 2 etc. etc.By writing a procedure, i can create a cursor, but is there any way to retrieve this info with 1 sql command only.. (which I can use in report)...