This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / How to use CASE WHEN in Access?
-greenspring(春天);
2004-9-20
{531}
(#1894781@0)
-
I am not sure Access can use CASE.
-ningxin0809(雁影行洲);
2004-9-20
(#1894789@0)
-
What function I can use in Access to achive the same result using Case When function in sql server?
-greenspring(春天);
2004-9-20
(#1894806@0)
-
Switch Function?
-charleslike(愚人);
2004-9-20
(#1894826@0)
-
I am not familair with Access, up for you.
-ningxin0809(雁影行洲);
2004-9-20
(#1894831@0)
-
Use Select Case Statement. The statement can only be used in the form as VBA code, not in SQL statement. In SQL statement, use IIF() instead.
-23456789(大白呼);
2004-9-20
(#1894977@0)
-
Thanks! IIF works.
-greenspring(春天);
2004-9-21
(#1895922@0)