Hi guys,

How can I retain my records for the month of January even I updated it during the month of February?

What I mean is?

For example for the month of January, I have inserted the following records;

Code:
ID     Quantity     Price     Total
10     2              30         60
11     1              20         20

Month of February comes, but I have to update ID 10 so the table becomes;

Code:
ID     Quantity    Price  Total
10     1             30      30
11     1             20      20
Month of March comes, but I have to update ID 10 so the table becomes;

Code:
ID     Quantity    Price  Total
10     3             30      90
11     1             20      20
Let's say this always happens for the succeeding year, ID 10 usually change its quantity and price.

Now the question is, as we all know that when we do an update the previous records will be replaced by a new one. How can I make a year end reports that will shows something like this?

Code:
Records of ID 10 for the year ___
January    February    March    April and so on and so forth
60           30            90           -
Note: ID Column must be unique, that's why I need to update instead of inserting a new record for the succeeding months.

Thanks in advance!