Using Case

From: Michael Marquardt (anonymous_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 07:41:47 -0700

Does Access suport the use of CASE in queries? I want to
avoid multiple iif statement and replace them with CASE.
Can I do this?
Thanks

Relevant Pages

  • RE: Using Case
    ... if your variable is a number that is a sequence. ... "Michael Marquardt" wrote: ... > avoid multiple iif statement and replace them with CASE. ...
    (microsoft.public.access.queries)
  • Re: Using Case
    ... >avoid multiple iif statement and replace them with CASE. ... the Switch() function in place of a multilevel IIF. ...
    (microsoft.public.access.queries)