Others: Count(IIf([P1_Master]![Teacher_Region]<>"Hyderabad",0)+(IIf([P1_Master]![Teacher_Region]<>"bangalore",0)+(IIf([P1_Master]![Teacher_Region]<>"Delhi",0)+(IIf([P1_Master]![Teacher_Region]<>"Chennai",0)+(IIf([P1_Master]![Teacher_Region]<>"Mumbai",0)+(IIf([P1_Master]![Teacher_Region]<>"pune",0)+(IIf([P1_Master]![Teacher_Region]<>"ROI",0)+IIf([P1_Master]![Remark]="mini kit",0))))))))
this is to find if i have entered any city name wrongly.