Help with Converting an Access query

Thanks for the reply Erland, compiles fine but when executed returns an error

Msg 208, Level 16, State 1, Procedure sp_SignOff_MonthCheck, Line 32

Invalid object name qry_MonthCheck.