Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quick question (In) (2000)

    Just a quickie.. does anyone know the limitation on the number of characters/items that can be used with the IN function?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Quick question (In) (2000)

    >>does anyone know the limitation on the number of characters/items that can be used with the IN function?<<

    This is just a small point, but there isn't an IN function in Access. There is an IN operator, such as used in an SQL Where clause. Is this what you mean? (IN is also a keyword, used in other situations).

    I don't know of any limitation on the IN operator. What kind of problem are you having?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick question (In) (2000)

    I assumed it was a function, as in In("A","B","C") which is the equivalent of "A" Or "B" Or "C".. but I can't force the help system to give me further information?! Andy.

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

    Re: Quick question (In) (2000)

    A SQL string can be about 64,000 characters long, according to the online help.
    As a test, I just created a SQL string with an In(...) part of over 33,000 characters; it was executed without a problem, so I guess there is no limitation to In(...) apart from the overall limit.

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Quick question (In) (2000)

    Are you actually have a problem using IN, or was it just a theoretical questions?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Quick question (In) (2000)

    Call up help from the Visual Basic Editor and search for In operator using the Answer Wizard. Select In Operator (Microsoft Jet SQL) from the topics.
    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
  •