Search results

  1. U

    Delete records from one table that appear in another table

    Hi all, Quick question... I have a master client table and a table of clients that have ordered from us, so don't want to be called again. I want to delete the clients record from the master table by comparing the two tables and sayi that 'everytime you find a phone number from the 'ordered'...
  2. U

    Delete Duplicartes Query

    Hiya - I created this simple delete query to delete all duplicate phone numbers from a master "Do Not Call List'...However it deletes ALL versions of the number from the table, including the original. What do I have to change so that it leaves 1 version of the number in the table? thanks in...
  3. U

    Join 2 Fields

    Hiya everyone 1st post. If this is already answered somewhere, please just point me there...I mange large amounts of data for different companies and use Access. I have to check a lot of the lists against State "Do Not Call Lists". Anyway the latest countrywide list is over 10,000,000 records...
Back
Top Bottom