add user name ?

F

Farid Sukkar

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;
 
G

George Nicholson

Maybe?:

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

HTH,
 
Top