I believe a correlated subquery will do what you want:
(SELECT SUM(Emps.Man_Hours) FROM Emps
WHERE Emps.Project_Record = Projects.Record) AS 'Man Hours'
ORDER BY Projects.Record;
but without table DDL I'm not sure of the exact relationship between the two tables, so I can't guarantee this. :)
Heed what David says about SELECTing *. It's handy to use in a discussion forum like this to signify "here's some columns", but it's really not a good idea in production code.
Custom Apps, Inc.