Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Keyword parameter (Access 2000)

    I have a query in which I want to include a parameter prompt so that the user can specify a keyword that the retrieved records must contain in either of two Keyword fields that contain strings of keywords.

    1. I tried creating a field Keywords: [Keywords1] & [Keywords2] with the criterion Like "*" & [Enter Keyword (Enter=All):] & "*", but this retrieves no records, whether the keyword is null or not. How can I correct this?

    2. Is it possible to go beyond this so that the user could enter multiple keywords and retrieve records where any of these words occurs in any order in either of the two Keyword fields, e.g., where [Keywords1] contains "one, two, three" and [Keywords2] contains "four, five, six" and the user enters "five one", or "five seven", or "fiv thre"?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Keyword parameter (Access 2000)

    You would have to do this with Or conditions: Like "*" & [Enter Keyword1] & "*" Or Like "*" & [Enter Keyword2] & "*"
    Charlotte

Posting Permissions

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