Form search for multiple values in single field

[ElmoTexas]

I have a table in which there are approximately 15k records. The name field has approximately 2500 unique values. I need to search the table for multiple names and return the results from the table. This would then be used as a report. Due to the users being very novice, a form is needed for the search.

Example:

Search for Smith, John; Wilson, Bill; Jones, Jeff

Return
Name Year Brand Make
Smith, John 1999 Oldsmobile 88
Smith, John 2001 Chrysler 300s
Wilson, Bill 1994 Porsche Carrera
Wilson, Bill 2007 Kia Sporty
Jones, Jeff 2004 Chevrolet Camaro
Jones, Jeff 2011 Chevrolet Impala

My knowledge of forms is basic, however, I can be a quick learner if on the right track.

Thanks in advance for any help and/or ideas.

 

[John Big Booty]

Welcome to the forum.

You would need to build a query based on your form and use the "Or" operator to search your field. This link should help you with that task.