Select GROUP BY under the field if you are in design mode.
If you are doing it in SQL view add a Group By clause.
SELECT Field1, Sum(Field2)
FROM SomeTable
GROUP BY Field1
If neither of those options answers your question, then perhaps you can
expand your question with a bit more detail as to what you want.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================