Results 1 to 5 of 5

Thread: delete query

  1. #1
    Join Date
    Apr 2005
    Posts
    44

    Unanswered: delete query

    Ok, I have two tables one stores training my staff want to do (wish list) and the other contains training my have are booked on/ have already completed.

    What I want to do is run a query that will find all occurances that appear in both tables and then delete them but i have no idea of where to start.... any ideas

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Delete them from where? Both tables? To find them, run/make a query that returns matching criteria common to both tables (I leave it to you to determine what criteria that is) ... Your options for deletion are wide open after that ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Apr 2005
    Posts
    44
    sorry i meant delete them from the wish list table.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You would probably be better off putting a "completed" checkbox or completion date on the "wishlist" table. When an employee takes or completes the class, mark your checkbox/completiondate accordingly.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by Teddy
    You would probably be better off putting a "completed" checkbox or completion date on the "wishlist" table. When an employee takes or completes the class, mark your checkbox/completiondate accordingly.
    Way to go Teddy, I was thinking the same thing exactly. You might someday need that old data. Later do a Query to Archive that data (Completed) to another table.

    laterz
    BUD

Posting Permissions

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