hi,
I have a table with 2 fields here : ID , Number
how can i sum up the Number where by the ID is the same in a query?

For example:

ID Number
------- -------
A 5
B 2
C 1
A 3
C 2

the result I want is:

ID Number
------- --------
A 8
B 2
C 3

Thanks in advance ...

try writing/pasting this code into a query (SQL view)

SELECT ID, SUM(Number) FROM 'table name'
GROUP BY ID

Actually you can see the design view afterwards.
Mihai

Thanks Mihai B , i got it