"M S Baker" <ms**@nbank.net> wrote in message
news:ll*****************@petpeeve.ziplink.net...
Is there any way to create a query similar to the old CASE statement in
FoxPro?
Alternatives in Access/Jet queries. Check Help file for...
Choose()
IIf()
Switch()
Or write a User-Defined function. The VBA code in that function can
utilize If-Then or Select-Case statements.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com