how to use if statement in Access 2007

[arpitraval]

Hi,

I am using Access2007 and working on one query in which i need the instructor's list but only those who are new and teaching the courses first time. So I have one list in which i have terms, courses, instructor name and few more. so is there any way to do it because may be one instructor did teach the same course in last semester which he is goin to teach this semester. "Only new instructors who is teaching first time in this semester"

Thanks

 

[khawar]

you have to give some more information about you table and how are you storing the data