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