SELECTPudID,
TranDate,
TranQty,
RunBal,
PudIDPct,
LotID,
PudIDLotBal,
LotIDBalSeq,
'help?'PudIDAsOfBal
may be I am being particulalary thick this morning but I cant seem to follow your spreadsheet for "Runbal" and "PudIDLotBal"....are these columns in your database table that are already populated by the application or are they columns that you created by some previous query?
[font="Courier New"]PudIDTranDateTranQtyRunBal
7519/19/11 18:216429864298
7519/20/11 3:20-4593864298
7519/20/11 3:204593864298
7519/20/11 3:21-1836060346
7519/20/11 3:211440860346
7519/20/11 18:162712287468
7519/20/11 19:5135454122922
7519/20/11 21:3012757121271
7519/20/11 21:30-14408121271
7519/21/11 2:0923515121271
7519/21/11 2:09-23515121271
7519/21/11 2:11-11939121271
7519/21/11 2:1111939121271[/font]
[font="Courier New"]PudIDTranDateTranQtyJLS runtot
7519/19/11 18:2164298
7519/20/11 3:20-4593818360
7519/20/11 3:204593864298
7519/20/11 3:21-1836045938
7519/20/11 3:211440860346
7519/20/11 18:162712287468
7519/20/11 19:5135454122922
7519/20/11 21:3012757135679
7519/20/11 21:30-14408121271
7519/21/11 2:0923515144786
7519/21/11 2:09-23515121271
7519/21/11 2:11-11939109332
7519/21/11 2:1111939121271[/font]
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day