Unanswered: Create a form to search and retrun multiple values
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.
Search for Smith, John; Wilson, Bill; Jones, Jeff
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.
G'd morning Elmo,
In general terms is not a difficult task. The problem might and will be how well your data is stored.
An access query should not contain , ; ( ) etc.
Names and last names should be stored in separated columns, brands should be a single table, models a single table.
Choose a naming convention for your object and stick to it. Once you get ready your tables and fields i'll try to assist you in any way i can.