Addition in a Query

[Jon]

Hi,

I'm trying to set up a query for a particular problem and am a bit
stumped. The data looks like this:

File # $Amount
B67 50
B67 80
B67 70
B68 20
B68 80
B69 90
B69 20
B69 40


I'd like the result to look like this:

File # $Amount
B67 200
B68 100
B69 150

So, another words, a query that would give me a unique File # and add
the $amounts together.

Thanks for any help you can offer.

Jon

 

[Duane Hookom]

SELECT [FileNum], Sum([Amount]) As AmtSum
FROM tblYourTable
GROUP BY [FileNum];

 

[Jon]

SELECT [FileNum], Sum([Amount]) As AmtSum
FROM tblYourTable
GROUP BY [FileNum];

Thank you for the help. Unfortunately, it didn't work. I got an error
saying "the Level clause includes a reserved word or argument that is
misspelled or missing, or the punctuation is incorrect".

 

[Duane Hookom]

What do you mean by "didn't work"? I am having trouble seeing your results.

Also, please post the SQL view of the query that "didn't work".

--
Duane Hookom
MS Access MVP

SELECT [FileNum], Sum([Amount]) As AmtSum
FROM tblYourTable
GROUP BY [FileNum];

Thank you for the help. Unfortunately, it didn't work. I got an error
saying "the Level clause includes a reserved word or argument that is
misspelled or missing, or the punctuation is incorrect".

 

[Jon]

SELECT [FileNum], Sum([Amount]) As AmtSum
FROM tblYourTable
GROUP BY [FileNum];

Thank you for the help. Unfortunately, it didn't work. I got an error
saying "the Level clause includes a reserved word or argument that is
misspelled or missing, or the punctuation is incorrect".

It worked. I had typed something in wrong. Thanks Duane.