I need to use clause CASE in queries but I don't find information on how to...
J jorge_bkr Jun 23, 2005 #1 I need to use clause CASE in queries but I don't find information on how to...
L Lynn Trapp Jun 23, 2005 #2 Access queries do not support a CASE statement. You can use it in VBA. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access queries do not support a CASE statement. You can use it in VBA. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
D Duane Hookom Jun 23, 2005 #3 You can use Switch() or IIf() or Choose() or Nz() or user-defined functions in Access queries.
