can report work a as a query

  • Thread starter Thread starter Alex
  • Start date Start date
A

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
 
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
 
Back
Top