Code:
SELECT Prospects.[Last Name], Prospects.Attachment, Prospects.[First Name], Prospects.Ht, Prospects.Wt, Prospects.College, Prospects.DoB, Prospects.Class, [First Name_Agents] & " " & [Last Name_Agents] AS [Agent Name], Agents.[First Name] AS [First Name_Agents], Agents.[Last Name] AS [Last Name_Agents], Agents.[Mobile Phone], Agents.[Business Phone], Agents.[E-mail Address], Prospects.[Primary Pos], Prospects.[2nd Pos], Prospects.Rehabilitation, Prospects.[Injury Date], Prospects.Injury, Prospects.Prognosis, [College Coaches].[Last Name] AS [Last Name_College Coaches], [College Coaches].[E-mail Address] AS [E-mail Address_College Coaches], [College Coaches].[Business Phone] AS [Business Phone_College Coaches], [College Coaches].[Mobile Phone] AS [Mobile Phone_College Coaches], [College Coaches].[First Name] AS [First Name_College Coaches], Colleges.Conference, Prospects.City, Prospects.State, Prospects.Country, Agents.Company, [College Coaches].School, Prospects.[AAU Team], Prospects.[AAU Coach], Prospects.[AAU Coach Cell], Prospects.[AAU Coach Office], Prospects.[AAU Coach Email], Prospects.[High School], Prospects.[High School Coach], Prospects.[HS Coach Cell], Prospects.[HS Coach Office], Prospects.[HS Coach Email], Prospects.[Prep School], Prospects.[Prep Coach], Prospects.[Prep Coach Cell], Prospects.[Prep Coach Office], Prospects.[Prep Coach Email], Prospects.JUCO, Prospects.[JUCO Coach], Prospects.[JUCO Coach Cell], Prospects.[JUCO Coach Office], Prospects.[JUCO Coach Email], Prospects.[International Club], Prospects.[International Coach], Prospects.[Intl Coach Mobile], Prospects.[Intl Coach Office], Prospects.[Intl Coach Email], Prospects.[Transfer College], Prospects.[Transfer Coach], Prospects.[Transfer Coach Cell], Prospects.[Transfer Coach Office Phone], Prospects.[Transfer Coach Email], Prospects.[Other Injuries], Prospects.[Position Rank], Prospects.[Overall Rank], Prospects.[Strength 1], Prospects.[Weaknesses 1], Prospects.Background, Prospects.Medical, Prospects.[Scouting Notes], Prospects.ID
FROM Agents INNER JOIN (Colleges INNER JOIN ([College Coaches] INNER JOIN Prospects ON [College Coaches].ID = Prospects.[College Coach]) ON Colleges.ID = Prospects.College) ON Agents.ID = Prospects.Agent
ORDER BY Prospects.[Last Name], Prospects.[First Name];