I NEED A EXAMPLE OF USING CHOOSE IN A QUERY

[GEM]

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

 

[Duane Hookom]

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")

 

[Lemark23]

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.