How do I indicate grouping in Access

[vince w]

select ? as the entry in the Total row for the field to be used for grouping

 

[Douglas J. Steele]

Care to expand on your question? I'm afraid I have no idea what you're
asking!

 

[John Spencer]

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
'====================================================