select case statement

[Guest]

i write this statement in a Query in MS-access " but my question " how can
write and change this statement to ( select case statement ) ........??
--------------------------------------------------------------------------------------------
SELECT Impsizetable.size
FROM Impsizetable
WHERE (((Impsizetable.size) Like "FCL*" Or (Impsizetable.size) Like "par*")
AND (([CurrentUser]) In ("Farid","sukkar"))) OR (((Impsizetable.size) Like
"LCL*") AND (([CurrentUser])="Admin")) OR (((Impsizetable.size) Like "* *")
AND (([CurrentUser])="test"))
WITH OWNERACCESS OPTION;
---------------------------------------------------------------------------------------------

 

[Tom Ellison]

Dear Farid:

Are you coding for Jet or MSDE here?

Why do you want to do this with a select case? Is this a syntax with which
you're familiar from somewhere else?

I don't see readily where a select case would fit into this. The only logic
is in the WHERE clause here. Is that what you want to rewrite? And why?

Tom Ellison

 

[Guest]

thank you very much to help me ...
i will tell you that my query is good working ..
but my question to you to change the query to
select case statement ... because i want to do
"Combo Box" and i put "event"
and i add the "select case statement" to the combo box when
i open it
"as a query i do" >>>
thank you for help me again ...

Dear Farid:

Are you coding for Jet or MSDE here?

Why do you want to do this with a select case? Is this a syntax with which
you're familiar from somewhere else?

I don't see readily where a select case would fit into this. The only logic
is in the WHERE clause here. Is that what you want to rewrite? And why?

Tom Ellison

i write this statement in a Query in MS-access " but my question " how can
write and change this statement to ( select case statement ) ........??
--------------------------------------------------------------------------------------------
SELECT Impsizetable.size
FROM Impsizetable
WHERE (((Impsizetable.size) Like "FCL*" Or (Impsizetable.size) Like
"par*")
AND (([CurrentUser]) In ("Farid","sukkar"))) OR (((Impsizetable.size) Like
"LCL*") AND (([CurrentUser])="Admin")) OR (((Impsizetable.size) Like "*
*")
AND (([CurrentUser])="test"))
WITH OWNERACCESS OPTION;
---------------------------------------------------------------------------------------------