Hi Debra,

Thanks!! it works.... i just have to modify the pivot table because the
QtyPos and QtyNeg if passed as it is, will return a Count function in
the pivot rather than Sum....

Otherwise, the sql statement works really great!

Thank you so much. You are a legend!