Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2006
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Restriction Query (Access 2000 SR 1)

    How do you restrict a query to pull the last two digits of a field. Eg. we want to restrict anything that ends in "40" in a four digit field?

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

    Re: Restriction Query (Access 2000 SR 1)

    Welcome to Woody's Lounge!

    One possibility is to put the following in the Criteria line for the relevant field:
    <code>
    Like "*40"
    </code>
    * is a wildcard standing for any number of characters.

  3. #3
    New Lounger
    Join Date
    Jul 2006
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restriction Query (Access 2000 SR 1)

    Thanks Hans

    We had <> "*40" and it was still pulling the fields that ended in 40. We have changed it to NOT LIKE "*40" and it works great.

Posting Permissions

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