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

[Tapan]

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

[orange]

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.

[ranman256]

normally, you dont update a row. you update a column.

[Tapan]

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

[Tapan]

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

[orange]

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.