The query is more complex than that, it pulls many tables and is grouped by the select fields, but I can add the SUM a a field. I was wondering if there is a setting on the report to accomplish this. It pulls 100s of lines and it can be consolidated bye each product with total quantity. Any other suggestions and thank you for your reply!!