can report work a as a query

[Alex]

I have a query with many columns. Some of them are

Product Territory Distributor Broker Country Qty1 Qty2
Qty3 ...

In addition to creating a report with grouping everything
together, I need to create reports taking some columns.
If I take in my report, for example, Territory (grouping)
and then Product (grouping), will my report show the sum
of Qty1, Qty2, ... or I need to create additional query
taking only these columns (with grouping) and finding the
sum of Qty1, ... and after that create a report based on
that?

The associated question is whether grouping and sum ina
query can give the same result for numbers.

Thanks

 

[Rick B]

Pull the data you wnat in the query. In your report, determine how you want
to sort and group. In your group footers, do your math to calculate totals.

Rick b


I have a query with many columns. Some of them are

Product Territory Distributor Broker Country Qty1 Qty2
Qty3 ...

In addition to creating a report with grouping everything
together, I need to create reports taking some columns.
If I take in my report, for example, Territory (grouping)
and then Product (grouping), will my report show the sum
of Qty1, Qty2, ... or I need to create additional query
taking only these columns (with grouping) and finding the
sum of Qty1, ... and after that create a report based on
that?

The associated question is whether grouping and sum ina
query can give the same result for numbers.

Thanks