Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter Queries (Access 97)

    I have a parameter query where I'm trying to use more than one parameter for the same field. Example: Cleveland And Detroit. When running the query, where it asks to enter parameter value i've tried CLEVELAND OR DETROIT, "CLEVELAND" OR "DETROIT", LIKE "CLEVELAND" OR LIKE "DETROIT" but nothing seems to be working.

    What am I doing wrong? Is there a better way?

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter Queries (Access 97)

    Check out the Knowledge Base article Q210530
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter Queries (Access 97)

    Go into QBE for your query and enter this string in you criteria.

    [First Choice] Or [Second Choice]

Posting Permissions

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