Results 1 to 2 of 2
  1. #1
    munkifisht is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2009
    Posts
    2

    Exclamation Use Table1 to update Table2? Urg Help needed

    I have 2 tables, I will simplify the situation. Say I have table1, it has the fields "ID", "Tag", "Date", and table2 and the fields "ID" "TAG". Table1 contains an old version of the dataset, and table2 is updated every so often.

    I want to do two things. First, I want to update Table1 with the new dataset on the either automatically or with the click of a mouse with the data that is in Table2.

    The other thing I want to do is I want to check that the data in Table1 is not unique, ie, if a value exists in table1 and not in table2, I want it removed, but I want it moved to a table called Dump so it can be reviewed before it is removed.

    Take this as an example

    Table1 "Tag" dataset
    Tag1
    Tag2
    Tag3


    Tag4

    Table2 "Tag" dataset
    Tag1
    Tag2
    Tag4
    Tag5

    This will become

    Table1 "Tag" dataset
    Tag1
    Tag2
    Tag4
    Tag5

    Dump "Tag" dataset
    Tag3

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Start by letting the query wizard create an "Unmatched" query for you.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Programmers help needed
    By n in forum Import/Export Data
    Replies: 3
    Last Post: 08-19-2011, 01:59 PM
  2. DSUM HELP needed
    By jjmartinson in forum Access
    Replies: 0
    Last Post: 07-21-2009, 01:47 PM
  3. Query Assistance Needed
    By elotromanuel in forum Queries
    Replies: 1
    Last Post: 03-17-2009, 09:31 PM
  4. Datediff() help needed
    By geoff44 in forum Access
    Replies: 2
    Last Post: 11-20-2008, 04:44 PM
  5. Help needed desperately
    By tinyuna in forum Access
    Replies: 0
    Last Post: 05-03-2007, 02:18 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