I'm trying to construct an SQL statement to return values from the Activity Table & Accounts Table.

I'm working with VBA which connects my Excel workbook to the Access database. At the moment, whenever I run this query it breaks and I can't figure out why as the whole program crashes. I think it has something to do with the sub queries for Outbound Calls, Credit Reviews & Correspondence Issued:

```sql
Select m.CaseManager, 
       sum(m.Lead) As 'Total Leads', 
       Count(m.AccountNumber) As 'Total Accounts', 
       Count(a.AccountNumber) As 'Total Activity', 
       (select count(accountnumber) 
        from ActivityTable 
        where Description like 'Outgoing Call%';) As 'Outbound Calls', 
       (select count(accountnumber) 
        from ActivityTable 
        where Description like 'Correspondence Sent%';) As 'Correspondence Issued', 
       (select count(accountnumber) 
        from ActivityTable 
        where Description like 'Credit%';) As 'Credit Reviews'
From AccountTable m, 
     ActivityTable a 
Group By m.CaseManager;

```