Making a Query that Sum's Numbers

[JRA]

Hello ...

I have data as illustrated below:

Serial Number Date Page Count
----------------------------------------------
123456 03/12/02 2
03/13/02 5
03/14/02 3

456789 03/13/02 2
03/14/02 8
03/15/02 5
03/16/02 5

What I want to do is create a query that will sum the page counts for each serial number? I am stuck on this and would appreciate any help.

Thanks in advance,
James.

 

[THoey]

SELECT [MyTable].[Serial Number],
SUM([MyTable].[Page Count]
FROM MyTable
GROUP BY [MyTable].[Serial Number] Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...