Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Thanked 0 Times in 0 Posts

    Delete query (Access 2000)

    My first field name in the table students is StudentID. i want to delete with one criteria all the stidentid numbers except studentid = 420. How can i use the <> signs ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Delete query (Access 2000)

    Simply enter <>420 in the Criteria row under StudentID. Make sure that you have changed the query to a delete query (Query | Delete Query).
    You can switch to datasheet view to check which records will be deleted, then switch back to design view and select Query | Run or click the Run button (the large <big><big>!</big></big> exclamation mark) to execute the delete query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts