Results 1 to 5 of 5
  1. #1
    CharissaBelle is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    81

    Need to Combine Two Tables

    Hello. I have two Vendor tables... oops... that I need to make into one table. My problem lies in that we have added vendors to both tables. Some vendors are only in tblVendors and some are only in tblPurOrdVend and some are in both. I want just a list of all my vendors in one table. I was going to use an append query, but I don't know how to not add the vendor if there is a duplicate vendor name. Any ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    join the 2 tables together on NAME,
    in an update query , update a field, say CITY to "DUPE"
    delete these records,
    now append the data.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In a COPY of your dB, I would do the append query.
    Create a "Find duplicates" query using the create query wizard.
    Now you can compare the duplicate records before deleting a record - maybe some records have been updated with newer data.

  4. #4
    CharissaBelle is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2016
    Posts
    81
    I forgot to mention that the one table is also joined to another table in a PK FK relationship. Will this update query effect these records?

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Yes, if you delete a duplicate record that is used as a FK in the other table.

    This is why you use a copy of the dB......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-11-2015, 11:44 AM
  2. Combine Tables
    By stbeaver in forum Queries
    Replies: 5
    Last Post: 02-26-2014, 11:15 AM
  3. How do I combine 3 tables into one?
    By Steven Seagal in forum Access
    Replies: 3
    Last Post: 09-18-2012, 06:54 AM
  4. combine two tables into one.
    By chad740 in forum Access
    Replies: 2
    Last Post: 08-31-2012, 01:12 PM
  5. combine two tables
    By boomkrekel in forum Access
    Replies: 5
    Last Post: 02-18-2012, 11:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums