Results 1 to 3 of 3
  1. #1
    Dominaz is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    21

    Macro transfer data for one table to another by columns

    Hello,
    I have one table with the following records:

    Name Surname School Date1 Date2 Date3
    John Smith London 12/12/11 11/11/11 10/11/11
    Mary Wayne Harvard 11/10/09 12/10/13 10/11/11


    I would like to design a Macro which can create another table like this :

    Name Surname School Date
    John Smith London 12/12/11
    John Smith London 11/11/11
    John Smith London 10/11/11
    Mary WAyne Harvard 11/10/09
    Mary Wayne Harvard 12/10/13
    Mary Wayne Harvard 10/11/11

    That is duplicate the records, and create another table, with all the records and each record with just 1 date.



    Thanks

  2. #2
    Toyman is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    233
    You don't need a new table; you need to fix the structure of your table. From the looks of your current table struction, you should have one main table containing the name information of the person. Each person should have a unique ID (primary key). You should have a second table for the dates. The date table should have the date field, a field to describe what the date is for and a ID field that relates to the primary key field of the person table (foreign key). This way, you just have one record for each person in the persons table an as many different dates related to the person in the related date table

  3. #3
    Dominaz is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    21
    Thank you very much!!

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

Similar Threads

  1. Transfer Data from Old DB to New
    By 1eye1vision in forum Import/Export Data
    Replies: 7
    Last Post: 08-06-2011, 02:12 PM
  2. Data Transfer
    By access_man in forum Access
    Replies: 0
    Last Post: 10-27-2010, 04:47 PM
  3. Data transfer and Mysql
    By fsmikwen in forum Programming
    Replies: 1
    Last Post: 02-25-2010, 11:42 PM
  4. Transfer data from ListView to Table
    By Zyckie in forum Access
    Replies: 1
    Last Post: 12-15-2009, 11:23 AM
  5. Replies: 3
    Last Post: 04-23-2006, 09:09 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