Group a column in a query

[benjamint]

Dear All,

I have the following question:

I've built a query with Microsoft Query, but unfortunately I get for example the following date when I run the Query:

Product Amount
A 5
B 6
A 2
A 1
C 1
D 3
D 3
C 4

I'd like to get the following date when I run the query (i'd like to get totals):


Product Amount
A 8
B 6
C 5
D 6

In Acces this is easy to do, by using the option SUM, but how do you do it in in MS Query? When I use the SUM icon in MS Query it's giving me an error message: Function SUM cannot be used with ..............

I will also paste below my SQL:

SELECT "TEST COMPANY$G_L Entry"."G_L Account No_", "TEST COMPANY$G_L Entry"."Posting Date", "TEST COMPANY$G_L Entry".Amount, "TEST COMPANY$G_L Entry"."Global Dimension 1 Code", "TEST COMPANY$G_L Entry"."Global Dimension 2 Code", "TEST COMPANY$G_L Entry"."Debit Amount", "TEST COMPANY$G_L Entry"."Credit Amount", "TEST COMPANY$G_L Account".Income_Balance<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
FROM NAV5Scheuten.dbo."TEST COMPANY$G_L Account" "TEST COMPANY$G_L Account", NAV5Scheuten.dbo."TEST COMPANY$G_L Entry" "TEST COMPANY$G_L Entry"<o></o>
WHERE "TEST COMPANY$G_L Entry"."G_L Account No_" = "TEST COMPANY$G_L Account".No_ AND (("TEST COMPANY$G_L Account".Income_Balance=?) AND ("TEST COMPANY$G_L Entry"."Posting Date">=? And "TEST COMPANY$G_L Entry"."Posting Date"<=?) AND ("TEST COMPANY$G_L Entry"."G_L Account No_"='26601'))<o></o>
ORDER BY "TEST COMPANY$G_L Entry"."G_L Account No_"<o></o>



Thanks in advance for your help!!!