Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    4

    Unanswered: Database maintenance

    Hi

    I was wondering if someone could help me, I'm trying to clean up some records on my database, I have managed to clean up a table of duplucate records, how ever this was in a relation to another table, is there anyway of clearing up the second table ie

    If this number does not exist in this column then delete the record.

    Would really appreciate it if any one could help, these are the two tables

    [Customers] [orders]
    Customerid Orderid
    firstname Customerid

    Thanks

    Ashley

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Run the Unmatched query wizard. Then morph that into a delete query ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jan 2005
    Posts
    4
    thanks. where do i find that wizard?

  4. #4
    Join Date
    Jan 2005
    Posts
    4
    sorry found it, thanks for your help

Posting Permissions

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