Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Not versus <> (Access 2003)

    What is the technical difference between NOT and <> <img src=/S/question.gif border=0 alt=question width=15 height=15>

    1. Is NOT more orientated to VBA and <> as a filter operator...
    2. When would be the best time to use NOT over <> and...
    3. Is NOT more powerful that the <> operater...

    TAI
    Regards,
    Rudi

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

    Re: Not versus <> (Access 2003)

    Not and <> have different purposes.

    <> is used in comparing two items. It results in True if the two items are not the same, and False if they are the same.

    Not negates the logical value after it; this may or may not involve a comparison. Examples:

    If Not IsNull(Field) Then

    If Not fld Is Nothing Then

    If Not lngA = lngB Then

    The latter is equivalent to

    If lngA <> lngB Then

    but for the other two, there is no equivalent using <>

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Not versus <> (Access 2003)

    Tx

    Negates says it all.
    Cheers
    Regards,
    Rudi

Posting Permissions

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