Problem with Query Report

[vanny]

Hi all,

I need some help with a query in a Report.

I need to group the Total Sum in quantity of a Product. These are based on the:

• MarketId
• Product Code
• Product
• Flavour
• Size

In the query I am listing all the above fields, thus it is giving me a list of Products that have been sold in all the Markets.
So for example if I need to know how many Chocolate Bars where sold having product code : 222222, it will give me the quantity of how many Chocolate Bars where sold in every Market.

What I need now is to group the number of Chocolate Bars and display it as a Total, irrelevant of which Market they had been sold to.

Any help will be much appreciated thanks a lot.

 

[Dennisk]

two ways to go.

1) create a totals query and group by Product Code and sum quantity.
2) create a report and use a group header for the product and dum the quantities in the group footer.