Results 1 to 6 of 6

Thread: access 2k2 query problem

Threaded View

  1. #1
    Join Date
    Aug 2003
    Posts
    7

    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
  •