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