Hi..
I am trying to filter a list by using the below formula in a query. But it doesnt work especially when i input <> and the result is nothing. Could anyone fix this issue for me.
IIf([Table1].[Location]="0217",<>"075",Last([EmployeeMaster].[empno]))
Regards,
Paul C:mad:
Simple Query Criteria- Plz Solve it!
I am trying to filter a list by using the below formula in a query. But it doesnt work especially when i input <> and the result is nothing. Could anyone fix this issue for me.
IIf([Table1].[Location]="0217",<>"075",Last([EmployeeMaster].[empno]))
Regards,
Paul C:mad:
0 commentaires:
Enregistrer un commentaire