Group and summarize using ExecuteSQL ( )

[Ron Cates]

I'm trying to wrap my head around using ExecuteSQL() to produce the following results but I could use some help.

I have a table of projects with a field for status. I would like to query the table to get a list of all the statuses and how many projects contain each status.

Active,10
Inactive,15
Cancelled,2
Completed,25

[comment]

How about:

SELECT Status, COUNT (*)
FROM Projects
GROUP BY Status

 

[Ron Cates]

Thanks