Recent content by leom808

already find a solution how to create the query that I want, but still looking for a solution how to create a "B/F column" and how to accumulate the previous month's qty into next month... :confused::confused::confused: i.e. ItemNum Balance (B/F_qty) Jan(In)_(Out)_(Bal)...

Hi all! I'm struggling in modify current crosstab sql statement in order to provide more I/O details on the query result. Following are the current detail: ----------------------------------------------- Table: TxnMst Fields: TxnDat Date/Time ItmNum Text (30) Qty Number (Long Integer) Table...