select case statement

F

Farid Sukkar

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

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
 
F

Farid Sukkar

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





Tom Ellison said:
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


Farid Sukkar said:
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;
---------------------------------------------------------------------------------------------
Click to expand...
Click to expand...
 
Top