Query Grouping

A

Adam

Hi All,

Another question! I've got a Select query which has Team and Case
Number and a date field which has a prompt on it.

I only have the team and case number shown And I've grouped it so it
performs a count on the case number. However, even though the date
isn't shown, it is only grouping the team and count of case number by
each day.

Is it possible to just group by Team with Count of Case No. ?

Adam
 
Top