1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access help

Discussion in 'Business Applications' started by BTex, Nov 9, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. BTex

    BTex Thread Starter

    Joined:
    May 10, 2002
    Messages:
    564
    I have two tables set up the same both are address database one old and one new , is it possible to let say compare first, name, and birth date, and if they don't match copy the non matching data from new to old?

    RC
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    Tables in and of themselves are not databases, but what you want to do is quite possible. There is a wizard for creating a duplicates query that can them be used as a make table query.
     
  3. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    The way that I normally handle this is to create a field in both tables which combines the First, name and DOB and then set that field to Indexed with No Duplicates to get Individuality. Sometimes you have to add something like an SSSN number or address to give true Individuality to get the No Duplicates.
    You obviously can't do that if it contains duplicates, which it shouldn't. If it contains duplicates you can create a Find Duplicates query to find them and remove them. Or create a copy of the table's structure only and set it's field to Indexed with No Duplicates.
    If you can do the first part with the original table you just create an Append query to append the new table's data to the old one. Any duplicates are ignored.
    If you have to use the second method because the first table already has duplicates you create an Append query for old & new tables to the new table.
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Or you could use a Query as Rockn suggests, but I think you would need a Find Orphan query rather than a find duplicates query. Otherwise you need to use the Duplicates data to exclude the records to be appended.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1026158

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice