Whats wrong with this code: Can any one solve this please:
((Table1.Location)=[Enter Project Number]) AND ((Table1.EmployeeID)=IIf([Location]="0217",[Table1].[EmployeeID],[Table1].[EmployeeID]) And (Table1.EmployeeID)<>287 And (Table1.EmployeeID)<>183 And (Table1.EmployeeID)<>264));
Its not giving me the result. May be the issue with <>. Is there any alternative method for this. Plz advise.
Regards,
Paul C:banghead:
Sql
((Table1.Location)=[Enter Project Number]) AND ((Table1.EmployeeID)=IIf([Location]="0217",[Table1].[EmployeeID],[Table1].[EmployeeID]) And (Table1.EmployeeID)<>287 And (Table1.EmployeeID)<>183 And (Table1.EmployeeID)<>264));
Its not giving me the result. May be the issue with <>. Is there any alternative method for this. Plz advise.
Regards,
Paul C:banghead:
0 commentaires:
Enregistrer un commentaire