Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prompt allowing OR (Access 97 SR-1)

    I want my query to prompt for criteria which I did by entering [Enter the code] in the criteria field but it won't let me enter multiple codes. When I try to enter 992 or 993, it won't return any records but 992 by itself does. How do I propmt myself to enter multiple criteria with OR between them? Thanks for the help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Prompt allowing OR (Access 97 SR-1)

    Microsoft has an MSKB article that provides two possible solutions, and also contains a link to a downloadable demo database. See ACC: How to Create a Parameter In() Statement.

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prompt allowing OR (Access 97 SR-1)

    Thanks. That article was perfect.

Posting Permissions

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