add user name ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How Can I Add User Name In This Query Statement ...
i mean that How can i add the user name [CurrentUser]
more than one user name as statement
like i want to add a new user
"Sukkar" to show Like "FCL*"
i will write this statement
(((Impsizetable.size) Like "FCL*") AND (([CurrentUser])="sukkar"))
How can i solve this proplem and i add the user in the same statement
-----------------------------------------------------------------------------------------
SELECT Impsizetable.size
FROM Impsizetable
WHERE (((Impsizetable.size) Like "FCL*") AND (([CurrentUser])="Farid")) OR
(((Impsizetable.size) Like "LCL*") AND (([CurrentUser])="Admin"))
WITH OWNERACCESS OPTION;
 
Maybe?:

WHERE (((Impsizetable.size) Like "FCL*") AND (([CurrentUser]) IN ("Farid",
"sukkar"))) OR ....

HTH,
 
Back
Top