Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2003
    Posts
    280

    Unanswered: Unable to filter a table with 'Not Like' code.

    It's giving me an error message of: Arguments are of the wrong type, are out of acceptable range, or are in conflict withone another.

    I try the filtering with 'Like' and it works. I don't know why 'Not Like doesn't work.

    Any ideas?..thanks..

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    post the query please.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Well, I have never seen "Not Like", but ! means not sor if you have 3 choices you can say !(A OR B) but it would be smarter just to call C, for speed.

  4. #4
    Join Date
    Sep 2003
    Posts
    228
    I made the mistake once of entering something like:

    If Me.field Not Like "test*" Then Do Something

    The following is the correct syntax:

    If Not Me.field Like "test"" Then Do Something

    Notice the position of the 'Not' operator.

    Could be your problem as well.

  5. #5
    Join Date
    Apr 2003
    Posts
    280
    rsMinUnit.Filter = "ICD9 Not Like '787.2' <---unable to do this
    rsMinUnit.Filter = "ICD9 Like '787.2' <----this work

    what is the problem?

  6. #6
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    rsMinUnit.Filter = "NOT ICD9 LIKE '787.2'"
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  7. #7
    Join Date
    Apr 2003
    Posts
    280
    Nope, doesn't work...

    Anymore ideas?

  8. #8
    Join Date
    Apr 2003
    Posts
    280
    Nevermind, I tried the '<>' and it worked. I don't know why it didn't work the first time..

Posting Permissions

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