Calculate the total value of a column in a query...

[EDUARDOELLOCO]

Hello friends,

I want to create a query that returns one value: the total (sum) of all values in a column of a table.

For example:

Let's say there is a table with 4 columns: Product, Quantity, Price and Value, being Value=Quantity * Price.
I want the query to return just 1 number: the Total Value for all Products in the table.

I hope it is clear and you can help me achieve that.

Thanks in advance,

Ed

 

[Joe4]

Welcome to the Board!

Do the following:
1. Create a new query, selecting your table as the source
2. Do NOT add any of the Table fields to your query, just add the following Calculated Field:

Value: [Quantity]*[Price]

3. Click on the Totals button in the Show/Hide ribbon in your menu (looks like a Sigma)
4. On the new Totals row it added under your Calculated Field, change the value from "Group By" to "Sum"

View your results. It should show one single number, the Sum of all the Values.

 

[EDUARDOELLOCO]

Thanks, Joe4 for your fast reply!

It worked perfectly!

 

[Joe4]

You are welcome!
Glad I could help!