#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    10
    Rep Power
    0

    Stupid Access Question


    Hello,

    Not much of an Access person myself (Mysql mainly) so I was wondering if I could get help with the simplest of things.

    How can I do this in Access.

    WHERE Artist='VARIOUS' AND Type!='SND';

    Thanks!

    --SL
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Sweden, in a pit, in the forest...
    Posts
    9
    Rep Power
    0
    Try to find the SQL button in one of the design menus (either for reports, questions etc.)
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    10
    Rep Power
    0
    Hello,

    Thanks for your reply.

    I think you misunderstood my post but thats ok because I figured it out.

    I was looking for help with !=
    Access doesn't support this. You have to use NOT. (What a pain)

    Thanks again,

    --SL
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Sweden, in a pit, in the forest...
    Posts
    9
    Rep Power
    0
    aha, got a little confused there.
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Canada - Egypt
    Posts
    60
    Rep Power
    12
    I think it is <>
    or NOT =
    I hope this is of any help to anyone.

    Yassoor
    http://www.WebsitesCreation.ca

IMN logo majestic logo threadwatch logo seochat tools logo