How do I find the sum of the values in a field?

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

Guest

I created a query and want to find the sum of the values in a specific field.
Does this need to be done using SQL?
 
Robert,
Using the query design grid, select View/Totals from the main menu, and place Sum in
the Total row of the field you want to add up.
By the by, when you use the query design grid, you're really creating SQL statements.
Check out View/SQL on any query and you'll see the SQL equivalent of your query. So, it's
easy to design using the grid, but you can also cut and paste the SQL statement from that,
and use it in a module.
 
You must log in or register to reply here.

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Sum totals not showing up in Queries or Reports 2
Summing Certain Records 1
Tweaking a calculated field in a query 4
Subtracting two sum fields on a seperate field on query 4
Unique values in two fields in query 1
DSUM?? 3
Access count a field in access report 2

Back
Top