same parameter is used multiple times in one qry

[JoJo S via AccessMonster.com]

I have a query that will allow users to search names, with last name and
first name entered separately with wild card through a parameter. How do I
have such flexibility as allowing users to enter 1 to multiple times of
different names through the parameter? The parameter set as following allows
the search of 1 name only. I can enter multiple of this line in the criteria
area, but I do not know how many names users may need to search.

Like [Enter last name] & "*" And Like "*" & [Ener first name:] & "*" & "*"

Thank you in advance.

 

[[MVP] S.Clark]

Create a form to capture all of the desired criteria. Parse the criteria
from the form to the Where clause. A subform, since there can be many, will
help.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting

 

[JoJo S via AccessMonster.com]

Thank you very much and please forgive my ignorance:

How do I parse the criteria from the form to the where clause?
Also, due to the table not normalized (It is from a data warehouse and I
don't have control over it), I have to put in the last name and first name in
the same field to query. How do I design my form so that it captures input in
this format "Smith,tony" and then query works as "Like Smith*sony*" in my
query?

Truely appreciate your help!

Create a form to capture all of the desired criteria. Parse the criteria
from the form to the Where clause. A subform, since there can be many, will
help.

I have a query that will allow users to search names, with last name and
first name entered separately with wild card through a parameter. How do I

[quoted text clipped - 8 lines]

Thank you in advance.