https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/88719.aspxSat, 06 Apr 2013 16:26:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88719Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/88719.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=88719<p>&nbsp;Yikes - I&#39;m having trouble understanding what you are saying - can you attach a screenshot under the Options tab that shows your form data structure?</p>https://www.infopathdev.com:443/forums/thread/88571.aspxTue, 02 Apr 2013 13:42:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88571pavkovlr0https://www.infopathdev.com:443/forums/thread/88571.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=88571<div class="body"> <p>Hello, I&#39;m creating an InfoPath form for use in a SharePoint document library. This library will store asset information. Each item in the library will have a corresponding update year and estimated cost&nbsp;that users will fill out in the InfoPath form&nbsp;that determines when the asset will need to be replaced and how much it will cost to replace it. I have 20 fields&nbsp;that correspond to 20 years (Year1Amt, Year2Amt etc. ) that will store the&nbsp;estimated upgrade cost of each item.&nbsp;The Year1Amt will always correspond to the current year. The problem&nbsp;is that&nbsp;at the end of the year, the Year1Amt will correspond to the new year, but all of the values stored in the Year1Amt column will still&nbsp;be the previous year amounts. I need a way to move all of the values over a year when the year changes. </p> <p>&nbsp;</p> <p>I hope this makes sense and someone knows of a solution.. This is the last hurdle I need to get over to finish this project! If I need to clarify anything to help you understand this problem, let me know.</p> <p>&nbsp;</p> <p>Lukas</p></div>