Results 1 to 6 of 6
  1. #1
    Tapan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2015
    Posts
    3

    How to update data in rows in one table from data in a single column of another table

    Hi all,



    I am facing problem while updating data in a row in one table(say Table1) from data in column in another table(say Table2).

    Table1(destination table) contains 7 fields in a single row (roll no,sub1,sub2,sub3,sub4,sub5,sub6) which need to be updated from data in Table2.

    The Table2(source table) has only 3 fields, i.e., roll no and subject code and marks.

    In Table2, Roll no field is the common field. subject code field contains 6 subject codes as sub1,sub2,sub3,sub4,sub5,sub6. Marks field contains 6 marks of corresponding subject codes as 21,22,23,24,25,26.

    I want to know how to populate marks from Table2 in Table1 under sub1,sub2,sub3,sub4,sub5,sub6.

    Please help at the earliest.
    Thanking you all
    Tapan

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,504
    From your description it sounds like your unnormalized data structure may be the issue.
    It is often better for communicating your issue to use an example of your data. Using hypothetical or analogies often confuses the real issue.

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,831
    normally, you dont update a row. you update a column.

  4. #4
    Tapan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2015
    Posts
    3
    Quote Originally Posted by Tapan View Post
    Hi all,

    I am facing problem while updating data in a row in one table(say Table1) from data in column in another table(say Table2).

    Table1(destination table) contains 7 fields in a single row (roll no,sub1,sub2,sub3,sub4,sub5,sub6) which need to be updated from data in Table2.

    The Table2(source table) has only 3 fields, i.e., roll no and subject code and marks.

    In Table2, Roll no field is the common field. subject code field contains 6 subject codes as sub1,sub2,sub3,sub4,sub5,sub6. Marks field contains 6 marks of corresponding subject codes as 21,22,23,24,25,26.

    I want to know how to populate marks from Table2 in Table1 under sub1,sub2,sub3,sub4,sub5,sub6.

    Please help at the earliest.
    Thanking you all
    Tapan
    Hi Dear,

    plz find attached access file and look into the issue.
    Table1 is to be updated from data in Table2.
    updatedTable1 is the resultant table which I have done Manually.

    You have to make a query for this.


    Thanks
    Tapan
    Attached Files Attached Files

  5. #5
    Tapan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Aug 2015
    Posts
    3
    Quote Originally Posted by Tapan View Post
    Hi all,

    I am facing problem while updating data in a row in one table(say Table1) from data in column in another table(say Table2).

    Table1(destination table) contains 7 fields in a single row (roll no,sub1,sub2,sub3,sub4,sub5,sub6) which need to be updated from data in Table2.

    The Table2(source table) has only 3 fields, i.e., roll no and subject code and marks.

    In Table2, Roll no field is the common field. subject code field contains 6 subject codes as sub1,sub2,sub3,sub4,sub5,sub6. Marks field contains 6 marks of corresponding subject codes as 21,22,23,24,25,26.

    I want to know how to populate marks from Table2 in Table1 under sub1,sub2,sub3,sub4,sub5,sub6.

    Please help at the earliest.
    Thanking you all
    Tapan


    Hi Dear,

    plz find attached access file and look into the issue.
    Table1 is to be updated from data in Table2.
    updatedTable1 is the resultant table which I have done Manually.

    You have to make a query for this.


    Thanks
    Tapan
    Attached Files Attached Files

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,504
    As I mentioned in the previous post, you have a table structure issue.

    I suggest you work through this tutorial.
    It will help you with table design and Normalization.
    You will learn a process for designing a database with relationships to support your business facts. (30-60 minutes)
    You have to work through the tutorial -- it does have a solution provided.

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

Similar Threads

  1. Replies: 6
    Last Post: 10-20-2014, 05:43 PM
  2. Replies: 3
    Last Post: 09-26-2012, 01:39 PM
  3. Replies: 11
    Last Post: 08-10-2012, 10:25 PM
  4. Replies: 10
    Last Post: 08-09-2012, 01:07 PM
  5. Replies: 5
    Last Post: 12-01-2011, 05:38 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 - Senior Forums