Okay try this ;
Code:
SELECT [Safety Learning Report].ID AS [Safety Learning Report_ID], [Safety Learning Report].[Corrected By], [Safety Learning Report].[Elimination Date], [Safety Learning Report].Created, [Safety Learning Report].[Reported By], [Safety Learning Report].Location, [Safety Learning Report].[Incident or Hazard Description], UserInfo1.Name, UserInfo1.ID, UserInfo_Copy.[Name] as CorrectedByName
FROM ([Safety Learning Report] INNER JOIN UserInfo1 ON [Safety Learning Report].[Reported By] = UserInfo1.ID) Inner Join UserInfo1 as UserInfo_Copy on [Safety Learning Report].[Corrected By] = UserInfo_Copy.ID
ORDER BY [Safety Learning Report].ID DESC;
It's untested but should give you an idea.
Also - please remove the spaces form your table and field names, all those square brackets become very tiresome to type out.
And as a helpful hint, in your tables change ID to something more meaningful (EmpID, ReportID etc) - leaving the primary key fields all called ID will trip you up later and makes reading things very much harder?
Finally, you may want to use a left join in case you haven't recorded a user ID in either field.