Results 1 to 2 of 2
  1. #1
    watergal82 is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Posts
    1

    Duplicate data fields

    I'm fairly new to Access, and have inherited a messy, badly designed database that I need to improve. Right now, I'm trying to consolidate duplicate data fields.



    I have the same field in 2 tables. Each table has data in the field, but the data in each table is for different dates. In the main table, the field was used through 2001, and then someone created a new table for this field. They didn't remove the old field, or move the data to the new field. The old dates only exist in the old table, the newer dates are in both tables, but only have data for this field in the newer table.

    Is there a simple way to consolidate the data from the two fields? I want all the data to be in the new table.

    I appreciate any help you can give me.

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,512
    If the fields for each table are identical in name, then you can do a Union Query to bring the data together. You cannot do a Make Table from a Union query, but once the union query is designed and run, you can then create a new select query based upon the Union query. Then change it to a make table query. You will then have a new table with all the data in one table.

    Alan

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

Similar Threads

  1. Replies: 3
    Last Post: 06-04-2010, 12:47 PM
  2. Replies: 1
    Last Post: 05-21-2010, 02:22 PM
  3. Duplicate data in report
    By JKrause in forum Reports
    Replies: 0
    Last Post: 03-23-2010, 10:07 AM
  4. Entering duplicate data in Form
    By cotri in forum Forms
    Replies: 1
    Last Post: 01-06-2010, 11:45 PM
  5. Prevent Duplicate Values on Combination of Two Fields
    By LornaM in forum Database Design
    Replies: 8
    Last Post: 05-05-2009, 11:16 PM

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