Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record total report....

Status
Not open for further replies.

Ben6550

Technical User
Jan 8, 2004
16
GB
I need to produce a query that returns just a total for a list of data within a access table column and display it in a report.
 
in the database window choose queries then new and design view. Coose the table then the column from your toolbar choose the sigma sign which will allow aggregation in the totals line choose sum and run it by clicking on the red exclamation mark.

Once you are happy with this go back to the database window and choose reports and new use the report wizard to walk your way through.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top