Total and Group By in a query

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

Guest

How would I go about the following?

I need to find the total amount of a field based on another field in the
same query.
EXAMPLE:
Need a total from [field or expression in query] and group it by another
field in the query to receive my results.

Such as: Need total amount {from field 1] based on (grouping) it with
another field in the query such as a field named "planID" to get my results.
Some of these fields that I will be totaling will be from query expressions
as well as fields from tables in my query. The grouping will always be from a
field in the query.

Thanks in advance for your help
 

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

How do you remove a Group By from a query? 2
Access Query problem 1
Creating a total query 4
Group by and Sum in same query 10
Group By Desing View 4
Count text values in a Access Field 0
Having Trouble with Sum in a Query 1
Access Dcount (multiple criteria) 3

Back
Top