Multi grouping on report

[FJM]

I have a report which lists amonst other things has two product categories A and B and gives a grand total of all the value of these products.


The query which runs the report has an expression which is (qty)*(value) to give the total value of each individual item
I would like to show on the same single report a seperate total value for all A type products and all B type products
Is this possible

[ItsMe]

Sometimes I will use VBA and DAO in the Open event. With this, I can execute a Totals Query Object that does not conflict with the Report's Grouping. I can then pass the variable retrieved via DAO to a control in the Report.

[FJM]

My understanding of Acees is limited so I don't really understand your reply.
Is it possible to offer a solution in simple terms ?

[ItsMe]

...
Is it possible to offer a solution in simple terms ?

If it is not possible to get the desired results using the tools offered within the Report Designer (like grouping, sorting, and expressions in unbound textboxes), probably not. Have you tried creating an expression within an unbound text box control?

Another approach might be using a subquery. If you create another query, using the Query Designer, you can add it to the original query, as a subquery. This may retrieve the data needed.

If these approaches do not work, you would need to resort to using VBA code in the Report's Module. This is sometimes referred to as "code behind the report".