Help with SUM expression

B

Brad Granath

I have a table with the following:

Column X | Column Y

2|Type1
2|Type1
3|Type1
6|Type1
4|Type2
2|Type2
5|Type2
1|Type2

I'd like to write a query that generate a sum of column x for each column y.
E.G:

Type1|13
Type2|12

I think this is accomplished with the SUM or DSUM function, but I can't
figure out how to write the query from the help files.
 
K

Klatuu

Open the query builder and select your table
Add each field to the query
Make it a Totals query - To do that, click on the Totals icon on the menu
bar. It looks like the Greek letter Sigma (sort of)
A new row will add to the builder.
Use Group Bu for Column Y and Sum for Column X
 

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

Parameter Query 3
Help with nulls, Nz, etc 5
Calculation in Query 1
Help with finding result from data 0
Counting multiple cells containing text. 1
Query with Percent 1
Report Totals 3
Change Data Layout 1

Top