Query Grouping

[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

 

[Guest]

In the design view for your query change the TOTAL line for the date to WHERE.