Sql

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

Sql

i have a table where i am maintaining the status of the record as completed or not using Yes/No.
now to generate the report i need to show (#record completed)/(#record), and there are some where clause also.

can i write like

SELECT [(Count(tbl_status = -1)/Count(tbl_status))*100] AS [Rate]" from tbl where.... group by....

Sql