Thanks CreganTur and ben.oates, but I'm still having problems!

Here's my SQL

[VBA]SELECT tblProjects.School, Format(nz(Sum(Switch([tblProjects].[Status]="Pending",[tblProjects].[DFC Y1],[tblProjects].[Status]="Approved" Or "Final" Or "Exceptionally Approved",0)),0),'?#,##0.00') AS [Amount in Progress], Format(nz(Sum(Switch([tblProjects].[Status]="Pending",0,[tblProjects].[Status]="Approved" Or "Final" Or "Exceptionally Approved",[tblProjects].[DFC Y1])),0),'?#,##0.00') AS [Amount Committed]
FROM ((tblLocalAuthority INNER JOIN (tblSchools INNER JOIN tblProjects ON tblSchools.[School Number] = tblProjects.School) ON (tblLocalAuthority.[Local Authority] = tblSchools.[Local Authority]) AND (tblLocalAuthority.[Local Authority] = tblProjects.[Local Authority])) INNER JOIN [tblDFC/School] ON (tblLocalAuthority.[Local Authority] = [tblDFC/School].[Local Authority]) AND (tblSchools.[School Number] = [tblDFC/School].School)) INNER JOIN tblInvoice ON (tblLocalAuthority.[Local Authority] = tblInvoice.LocalAuthority) AND (tblSchools.[School Number] = tblInvoice.School) AND (tblProjects.[Project Number] = tblInvoice.Project)
GROUP BY tblProjects.School;
[/VBA]