about case syntax and how to use it

[amit]

hi this is amit bohra.
i want to know what is the syntax of case structure used
in access 2000. how to use the when and then commands in
case structure. or is there any other alternative to find
a item from a multiple choice in an select query.do mail
me as soon as possible.

 

[John Vinson]

hi this is amit bohra.
i want to know what is the syntax of case structure used
in access 2000.

Access JET SQL does not support the CASE structure. It's available in
SQL/Server, and it's part of the ANSI standard, but it just wasn't
implemented in Access.

how to use the when and then commands in
case structure. or is there any other alternative to find
a item from a multiple choice in an select query.

An IN clause will work:

SELECT ...
WHERE fieldname IN ("this", "that", "theother"

do mail
me as soon as possible.

Private email support is for paying clients. If I, as an unpaid
volunteer like all the other volunteers here, can come to the
newsgroup to answer questions, it should be worth your time to come
back to the newsgroup to read the answer. Copied to email, but please
reply to the newsgroup.