Results 1 to 2 of 2
  1. #1
    Tony Gater

    Help on Access97 query

    I am trying to create a query to show me which records have been deleted from an "purchase order file", I have 2 tables viz.tbl1"before", this shows the file before any deletion takes place.
    tbl"after", this shows the file after deletion, the query I want to create is supposed to show the record that is deleted. (i.e. the record exists in tbl"before" but not in tbl"after") to illustrate this I have attached a sample database complete with the queries I have tried to get the result from.
    thanks in advance
    Tony Gater

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    The Netherlands
    Thanked 0 Times in 0 Posts

    Re: Help on Access97 query

    SELECT ID, ...... FROM tblBefore WHERE ID NOT IN (SELECT ID FROM tblAfter)

Posting Permissions

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