yes ar, Access sql .....
So i don't know how to post my sturture........

tablename: Candidate
----------------------------------

candidate_id char(key)
candidate_no char

tablename: Education
----------------------------------
education_id char(key)
candidate_no char

tablename: Working
----------------------------------
working_id char(key)
candidate_no char
w.from_year int
w.to_year int

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
 having  sum(datediff('yyyy','01/01/' & w.from_year ,'01/01/' & w.to_year )) >= 1

what is my wrong in this statement ?
Anyone know how can i do, please thx?