Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2005
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query with like (Access 2000)

    I want to set the parameter of a query to like' tronic' to look for names with tronic,but i get emtpy fields. Whys is that ?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query with like (Access 2000)

    Can you post the sql you use ?
    Francois

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: query with like (Access 2000)

    Do you want names starting with tronic,
    use Like "tronic*"

    or names where tronic is in any part of the field
    use Like "*tronic*"

    If tronic the only letters in the field
    use = "tronic"

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: query with like (Access 2000)

    Hi there

    How about


    Like '*tronic*'
    Jerry

Posting Permissions

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