HI, ALL
I don't konw my sql statement have what problem? And how do solve?
i use Access, i check the problem is in sum(datediff('yyyy','01/01/' & w.from_year ,'01/01/' & w.to_year )) >= 1, but i don't know

select distinct (c.candidate_no)  FROM ((candidate as c left JOIN education as e ON  c.candidate_no = e.candidate_no ) left Join working as w ON c.candidate_no = w.candidate_no )group by c.candidate_no,c.last_name ,c.nick_name, IIf( c.dob = '  /  /',0,DATEDIFF('yyyy',c.dob,now) ) , c.mobile,c.expect_salary,c.available_option,e.level,e.institute,w.Industry,w.work_position,w.place,w.employer,w.duty,w.Achievement having 1 = 1 and sum(datediff('yyyy','01/01/' & w.from_year ,'01/01/' & w.to_year )) >= 1