Results 1 to 2 of 2
  1. #1
    Paul D is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    1

    Query for multiple values

    Hi

    New to Access, I was wondering if there is an easy way to return multiple vales on a query,

    for example, I need to return data from column B for multiple values in column A

    So I need to search for
    2MA007
    and
    2MA020
    and find information for both

    Column A Column B
    2MA007 007 Appt Card 50pc Harmony
    2MA010 (D) 010 Appt Card 50pc Tranquil
    2MA011 011 Appt Card 50pc Sexy
    2MA019 019 Appt Card 50pc Rose
    2MA020 020 Appt Card 50pc Nat French
    2MA021 021 Appt Card 50pc City Chic
    2MA023 023 Appt Card 50pc Caresse
    2MA031 031 Appt Card 50pc Pearls
    2MA033 033 Appt Card 50pc Eden
    2MA035 035 Appt Card 50pc Pasha Red
    2MA039 039 Appt Card 50pc Oasis
    2MA044 044 Appt Card 50pc Red Rose
    2MA045 045 Appt Card 50pc Massage
    2MA046 046 Appt Card 50pc Spa Massage
    2MA047 047 Appt Card 50pc Lilly



    I appreciate the help, thanks


  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    One way, if it's for a form or report:

    http://www.baldyweb.com/multiselect.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2017, 12:11 AM
  2. Replies: 3
    Last Post: 10-30-2016, 05:50 AM
  3. Multiple Query Values In A Report
    By dr4ke in forum Reports
    Replies: 10
    Last Post: 01-29-2013, 07:32 AM
  4. query field with multiple values
    By mknowles in forum Queries
    Replies: 1
    Last Post: 11-24-2009, 11:31 AM
  5. Query multiple values in a field
    By JAYgarti in forum Access
    Replies: 0
    Last Post: 07-09-2009, 09:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums