Parameter Query

[Guest]

I have a simple parameter query. I want a user to be able to type in one,
two, three or even four different criteria for their result set.
Example: the field name is LastName. In the criteria area, I put in [enter
last name] which prompts the user for input. I would like the user to be
able to input a multitude of last names rather than just one: e.g. when
prompted, she types in Smith, Jones, Johnson, Jehosephat. And the result set
will return all persons with that last name. I only know how to have the user
input one particular last name at a time. What do I use for separation? I've
tried various things and nothing seems to work.
Thanks in advance for help - I'm sure it's an easy answer!
Linda

 

[Ken Snell \(MVP\)]

Cannot be done using the parameter approach. You'll need to use a form that
allows the user to select / enter the multiple choices and then run code to
create an SQL string and execute that string.

See sample database at this URL for example of how this can be done:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[Guest]

Darn - I thought it would be a 'no-brainer'.
Thanks for your reply - I'll take a look at this - I like the idea of using
a form to filter data.
Linda

Cannot be done using the parameter approach. You'll need to use a form that
allows the user to select / enter the multiple choices and then run code to
create an SQL string and execute that string.

See sample database at this URL for example of how this can be done:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

I have a simple parameter query. I want a user to be able to type in one,
two, three or even four different criteria for their result set.
Example: the field name is LastName. In the criteria area, I put in
[enter
last name] which prompts the user for input. I would like the user to be
able to input a multitude of last names rather than just one: e.g. when
prompted, she types in Smith, Jones, Johnson, Jehosephat. And the result
set
will return all persons with that last name. I only know how to have the
user
input one particular last name at a time. What do I use for separation?
I've
tried various things and nothing seems to work.
Thanks in advance for help - I'm sure it's an easy answer!
Linda