February 21st, 2003, 11:00 AM
Stupid Access Question
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';
February 21st, 2003, 02:07 PM
Try to find the SQL button in one of the design menus (either for reports, questions etc.)
February 21st, 2003, 02:31 PM
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)
February 21st, 2003, 02:33 PM
aha, got a little confused there.
February 22nd, 2003, 10:47 PM
I think it is <>
or NOT =