Count And Sort

Question

User-1186309636 posted

Hi,

I have a table of records in an access database and need to count and group by separate columns.

The table is called CASES and I need to count records from a certain date range then group them by person from a column called INDIVIDUAL THEN sort within that individual by CASETYPE and display the record cound for each separate individual  and case type.

It's for reporting functionality and have no idea where to start with this. Any assistance would be very much appreciated. :-)

Answer 1

User761909039 posted

Here is the SQL query you are looking for..

 

SELECT INDIVIDUAL, CASETYPE,Count(*) 
FROM CASES
WHERE DateColumn BETWEEN @DateStart AND @DateEnd
GROUP BY INDIVIDUAL, CASETYPE
ORDER BY INDIVIDUAL ASC, CASETYPE ASC

Answer 2

User-1186309636 posted

Thanks heaps! Worked like a charm! :-)