-
access 2k2 query problem
hi,
i am currently using MS access 2002 and i have a problem regarding the following table...
*Name *Item Number
--------------------------------------------
john ball
john watch
john computer
john telephone
*Primary key
The whole of number column is empty, and the primary key is Name and Item.
i wanted to select all the rows except for, say, the first row...
i use the following query string:
SELECT * FROM table1 WHERE Name<>'john' AND Item<>'ball';
the result return nothing, why is that so??
thz in advance
Last edited by 0133892; 08-01-2003 at 01:28 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|