Here is the query
finalQry = "select ((Nz(FirstName, legal_name)) & (' '+ MiddleName) & ' ' & LastName) as fullname,('" + vFolderPath + "' & EmployeeId & '\profile_pic.jpg') as ImagePathJPG, ('" + vFolderPath + "' & EmployeeId & '\profile_pic.png') as ImagePathPNG,* from qry_people_not_merged...