Seperating data in a query!

[robk5787]

I have a few hairs left to pull out, but I like the new Homer Simpson look. Could someone please help me out with this? I am kind of new to Access, but anxious to learn. I have a Like criteria that ask for the user to input a building name (i.e. Memphis), and it works great. A few people that will be using this DB want to be able to enter more than one building name at a time. I thought about a Pivot Table, but there is too much other information associated with the buildings being entered that it takes forever to run. Someone I work with says that there is a way to use a separator (i.e. a comma or semicolon) to enter more than one building (i.e. Memphis; Bartlett; Nashville). Any help is greatly appreciated. Once you get working to their needs, they want the luxuries!!

Thanks!

 

[Rich]

Article ID: Q100131

 

[robk5787]

What does this mean? I am unfamiliar with Article ID: Q100131.
Please explain!

 

[Hayley Baxter]

You can find the article here:

Q100131

 

[robk5787]

Well that is kind of what I was hoping for, but unfortunately, I would also like to be able to use a wild card due to the number of buildings with sub names (i.e. Memphis Package - Memphis* or Bartlett Hub - Bartlett*). Is there any end to this madness. I am really trying to stay away from VB, but it does not look hopefull.

Any help?