Help with SUM expression

[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.

 

[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