 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / August 2005I NEED A EXAMPLE OF USING CHOOSE IN A QUERY
I am working on a form using an select box as a filter it works fine but now I need to select more then one location. I was thinking about using choose in a query I need to see an example of using choose Did you try open a module window and press [F1] and search Help? Choose() expects first argument of an integer. The other arguments are returned based on the integer. For instance: BirthStone: Choose(Month([DOB]), "Garnet","Amethyst",...,"Turquoise") or PriorityName: Choose([Priority],"High", "Medium","Low")  SignatureDuane Hookom MS Access MVP -- >I am working on a form using an select box as a filter it works fine but >now > I need to select more then one location. I was thinking about using choose > in > a query I need to see an example of using choose I am not a filter wiz, but your title suggests you are manipulating a query. I do this all of the time to get the right records out to users. If you are using SQL to manipulate the recordsource for your form, it is easy to build in multiple items to an IN statement. > I am working on a form using an select box as a filter it works fine but now > I need to select more then one location. I was thinking about using choose in > a query I need to see an example of using choose |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.