Sum in reports

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a report with the following fields(from a query):
Data Material_Code Item_Code Items Name Quantity re_done
Unit_Price Total_Price

How can I display the SUM of Items for any change of the Data,
Material_Code, Item_Code Name or re_done ?

Thanks!
 
Oops. This solution works well in Group and Report Headers and Footers but
not Page sections.

I am confused about the "any change of the Data" part. Typing a few records
with desired output is invaluable when posting report questions.

--
Duane Hookom
MS Access MVP


Arvin Meyer said:
In the report and/or page footer (depending upon what you'd like to sum) set
the controlsource to:

=Sum([YourFieldName])
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Chris said:
I have a report with the following fields(from a query):
Data Material_Code Item_Code Items Name Quantity re_done
Unit_Price Total_Price

How can I display the SUM of Items for any change of the Data,
Material_Code, Item_Code Name or re_done ?

Thanks!
Click to expand...
Click to expand...
 
Back
Top