Hi

I have a report that shows all the orders for a range of products. I also have the available stock of each product. The grand total of the product is incorrect e.g if I have 10 in stock of one product and 10 in stock of another product they are both used in 3 orders. If I add a grand total, of what is in stock it should be 20, however it is coming out as 60, as there are 3 instances of each. Hope that makes sense. Any help much appreciated.
Ed

Thank you for your help. It's directly from the tables, I think I may have to look at sub reports - or send it to excel and total it there.

Thanks again.

Thank you I will try that.