Sum in a report

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

Guest

I have a report grouped by product category. Under each category is a list
of products and their extended purchased price ([Quantity]*[Price]). I would
like to only show the product category and the sum of all the extended
prices, which in turn would give me totals for each category, without having
to view all the detail in the report. Thanks
 
I have a report grouped by product category. Under each category is a list
of products and their extended purchased price ([Quantity]*[Price]). I would
like to only show the product category and the sum of all the extended
prices, which in turn would give me totals for each category, without having
to view all the detail in the report. Thanks
Click to expand...

Include the extended price in the Report's Recordsource query as a
calculated field, and use the report's Sorting and Grouping feature to
group by Category. Don't put any controls in the detail section, but
put the category and a textbox with =Sum([ExtendedPrice]) in the
Category footer section.

John W. Vinson[MVP]
 
Back
Top