Two methods:

SELECT Projects.[Job Number]

FROM Projects

WHERE Projects.[Job Number]=(SELECT TOP 1 Survey.job_num FROM Survey ORDER BY Survey.SurveyID DESC)

or

declare @intmyint as integer

set @intmyint = (SELECT TOP 1 Survey.job_num FROM Survey ORDER BY Survey.SurveyID...