Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    1

    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.

    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.

  2. #2
    Join Date
    Sep 2005
    Posts
    3
    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.
    G'd luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •