Here it is.
SELECT [LSC - EBS - Funding - Combined Funding].[Cost Centre], Sum([LSC - EBS - Funding - Combined Funding].[16-18 Income]) AS [SumOf16-18 Income], Sum([LSC - EBS - Funding - Combined Funding].[Adult Income]) AS [SumOfAdult Income], [LSC - FIMO - Funding].[Cost Centre], Max([LSC - FIMO - Funding].[Budget 16-18 Income]) AS [MaxOfBudget 16-18 Income], Max([LSC - FIMO - Funding].[Budget Adult Income]) AS [MaxOfBudget Adult Income]
FROM [LSC - EBS - Funding - Combined Funding] INNER JOIN [LSC - FIMO - Funding] ON [LSC - EBS - Funding - Combined Funding].[Cost Centre] = [LSC - FIMO - Funding].[Cost Centre]
GROUP BY [LSC - EBS - Funding - Combined Funding].[Cost Centre], [LSC - FIMO - Funding].[Cost Centre]
UNION ALL
SELECT [LSC - EBS - Funding - Combined Funding].[Cost Centre], Sum([LSC - EBS - Funding - Combined Funding].[16-18 Income]) AS [SumOf16-18 Income], Sum([LSC - EBS - Funding - Combined Funding].[Adult Income]) AS [SumOfAdult Income], [LSC - FIMO - Funding].[Cost Centre], Max([LSC - FIMO - Funding].[Budget 16-18 Income]) AS [MaxOfBudget 16-18 Income], Max([LSC - FIMO - Funding].[Budget Adult Income]) AS [MaxOfBudget Adult Income]
FROM [LSC - EBS - Funding - Combined Funding] LEFT JOIN [LSC - FIMO - Funding] ON [LSC - EBS - Funding - Combined Funding].[Cost Centre] = [LSC - FIMO - Funding].[Cost Centre]
GROUP BY [LSC - EBS - Funding - Combined Funding].[Cost Centre], [LSC - FIMO - Funding].[Cost Centre]
HAVING ((([LSC - FIMO - Funding].[Cost Centre]) Is Null))
UNION ALL
SELECT [LSC - EBS - Funding - Combined Funding].[Cost Centre], Sum([LSC - EBS - Funding - Combined Funding].[16-18 Income]) AS [SumOf16-18 Income], Sum([LSC - EBS - Funding - Combined Funding].[Adult Income]) AS [SumOfAdult Income], [LSC - FIMO - Funding].[Cost Centre], Max([LSC - FIMO - Funding].[Budget 16-18 Income]) AS [MaxOfBudget 16-18 Income], Max([LSC - FIMO - Funding].[Budget Adult Income]) AS [MaxOfBudget Adult Income]
FROM [LSC - EBS - Funding - Combined Funding] RIGHT JOIN [LSC - FIMO - Funding] ON [LSC - EBS - Funding - Combined Funding].[Cost Centre] = [LSC - FIMO - Funding].[Cost Centre]
GROUP BY [LSC - EBS - Funding - Combined Funding].[Cost Centre], [LSC - FIMO - Funding].[Cost Centre]
HAVING ((([LSC - EBS - Funding - Combined Funding].[Cost Centre]) Is Null));
Basically it is the joining of 3 queries, all of which show numbers, but the results of this show as text.