Totaling all values in a column and showing the results.

R

Rick

I have a Access 97 DB. I have a quantity column. I want to
add all the values in this column and show the total on a
report or a query. The "help" is not helping. Can some one
please try to help the helpless?
 
D

Duane Hookom

Add a text box to the Report Footer (NOT Page Footer) with a control source
like:
=Sum([YourNumericField])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
List all tables, including document structure 0
Calculate the median value before a specified list 0
How to display zero value in blank fields of Cross Tab query 0
Drop down lists in seperate columns 5
Grand Total for a calculated column - Access 2007 1
Cross Tab Report Vs Dynamic coulmns 0
formula for arriving net difference 0

Top