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

    2 Quick Q's (Access 2000>)

    1. What is the difference between <> and Not as filter operators. (I know that Not is more powerful! If I use <>"*"( as null) there is a syntax issue; but if I use NOT "*" it works)

    2. Some built in functions end with $. Whats the significance of the $? eg. You have Format and Format$ function; they both work, but the wizard usually uses the $ functions???.
    Regards,
    Rudi

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

    Re: 2 Quick Q's (Access 2000>)

    First of all, don't trust wizard code. It is frequently archaic and not necessarily the best way of accomplishing something.

    1. Not is a boolean keyword. It doesn't mean not equal, it means not "something" and it is used in logical comparisons and can be used with things like Null (which can't be compared any other way in VB/VBA) and Nothing. Not equals (<>) compares two values. Since Null doesn't compare to anything, you have to use NOT when testing nulls, or use the Nz function to insure that there is *something* in the expression to compare.

    2. The $ means that the function returns a string. Those without the $, like Format, return a variant that happens to contain a string. It's a difference that seems to make no difference, but the Format$ is more efficient since variants are expensive in terms of resources.
    Charlotte

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

    Re: 2 Quick Q's (Access 2000>)

    Thanx for that clear explanation Charlotte!
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    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
  •