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

    Text Query (2002 SP3)

    I have a field with values such as MB, S, PP, C-W, PRYCE, JONES and so on, each separated by a comma and a space. I'm trying to do a query to find records that contain "C-W" and "PRYCE", but not just these two or one or the other. I'm thinking there must be a way of doing this, but my Access skills are pretty rusty

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

    Re: Text Query (2002 SP3)

    You can use the following condition in the Criteria line for the text field:
    <code>
    Like "*C-W*" And Like "*PRYCE*"</code>

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Query (2002 SP3)

    Thanks Hans!

Posting Permissions

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