Grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query for a record sorce. The query contains the following fields
(totalsale, shipping, tax, JurCode, and Busstype). Each sale has a bussiness
type and Juristicion Code. I want to print a report that will give me
complete sums listed per the bussiness types and sums listed per juristicion
Code. How can i do this using one report?

Thanks for any help

Jason
 
Jason said:
I have a query for a record sorce. The query contains the following fields
(totalsale, shipping, tax, JurCode, and Busstype). Each sale has a bussiness
type and Juristicion Code. I want to print a report that will give me
complete sums listed per the bussiness types and sums listed per juristicion
Code. How can i do this using one report?
Click to expand...


I'm thinking the best way to do this is to create a Totals
type query for each set of sums:

SELECT JurCode,
Sum(TotalSale) As TotalAllSales,
Sum(Shipping) As TotalAllShipping,
. . .
FROM sometableorquery
GROUP BY JurCode

Then create reports based on each query and use them as
subreports in the main report's header/footer section.
 
Back
Top