select status in a query

[Guest]

I have a table with account information. One of the fields is Account_Status,
there are 6 possible choices for account status going from 1 - 6. Wha I'd
like to do is run a qurey where the user can choose to return accounts with
status 4 or 6. Any help appreciated. I can use "between and" ut this returns
to much information if I need just 3 or 6. It also has to be user friendly as
I do not want someone in the query.

Any help appreciated.

Thanks
Jo

 

[Ken Snell \(MVP\)]

See sample database at this site:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

Look at how the listbox is set up (multiselect) to allow selection of
multiple values for the query's search. Then look at the programming to see
how the SQL statement is generated so that the chosen values are used in the
search. One note -- the programming in this sample database assumes all
values chosen in the list box should be matched (you'll see use of "AND" in
the SQL statement's WHERE clause)) -- change AND to OR and modify the code
as needed.

Post back with questions.