how to simplify this query..............plz help

[lalprasad]

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.

[June7]

Maybe:

SELECT * FROM P1_Master WHERE Remark="mini kit" AND NOT Teacher_Region IN ("Hyderabad", "Bangalore", "Delhi", "Chennai", "Mumbai", "Pune", "ROI");

Otherwise, build a table with the valid city names and join it to Teacher_Region in a Find Not Matched query - there is a query wizard for that.

[lalprasad]

Maybe:

SELECT * FROM P1_Master WHERE Remark="mini kit" AND NOT Teacher_Region IN ("Hyderabad", "Bangalore", "Delhi", "Chennai", "Mumbai", "Pune", "ROI");

Otherwise, build a table with the valid city names and join it to Teacher_Region in a Find Not Matched query - there is a query wizard for that.

thank you