You're welcome!
You should be able to change the summary function from Count to Sum, in
the Pivot Table. If not, in the formulas, you can change the Null to a zero.

tedy wrote:
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!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html