Here is the SQL View. Thanks!

[Golfinray]

SELECT [Districts 2006 2007].DISTRICT, [06-07 Project Table].[School Name],
[06-07 Project Table].[Project Description], Transitional.[Project
Description], AFIRP.[Project Description]
FROM (([Districts 2006 2007] INNER JOIN [06-07 Project Table] ON [Districts
2006 2007].[LEA new] = [06-07 Project Table].[District LEA]) INNER JOIN
Transitional ON [06-07 Project Table].[District LEA] = Transitional.LEA)
INNER JOIN AFIRP ON Transitional.LEA = AFIRP.LEA
ORDER BY [Districts 2006 2007].DISTRICT;