Code:
SELECT Prospects.[Last Name], Prospects.Attachment,
Prospects.[First Name], Prospects.Ht, Prospects.Wt,
Prospects.College, Prospects.DoB, Prospects.Class,
Agents.[First Name] AS [First Name_Agents],
Agents.[Last Name] AS [Last Name_Agents],
Agents.[Mobile Phone], Agents.[Business Phone],
Agents.[E-mail Address]
FROM Agents INNER JOIN
Prospects ON Agents.ID = Prospects.Agent;
if you want to nail the problem down to something within the report itself, paste this sql into a new qry sql window and run it. does it error? if not, the report is the problem