http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/22791.aspxTue, 05 Aug 2014 14:18:02 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:22791Method_Greg0http://forums.method.me/cs/forums/thread/22791.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=22791<p><span style="overflow:hidden;" id="mce_0_start"><br />Hello Michele, <br /><br />&nbsp;&nbsp;&nbsp;&nbsp; You would not be able to change a text field to a numeric field.&nbsp; Two options come to mind.<br />&nbsp;<br />&nbsp; 1. Do an <span style="overflow:hidden;" id="mce_1_start"></span><a href="http://www.methodintegration.com/method/kb.aspx?folder=MethodCRM&amp;article=Import-%2f-Export&amp;id=189">import update<span style="overflow:hidden;" id="mce_1_end"></span></a>.&nbsp; Create your new field on the target table.&nbsp; Export the RecordID and one other field that you can use as a unique reference field.&nbsp; Copy and paste the packsize data to match the correct record using RecordID and your unique field.&nbsp; Then do an import update.<br /><br />&nbsp;&nbsp; 2. You can create a brand new screen.&nbsp; The logic would be similar to the <span style="overflow:hidden;" id="mce_4_start"></span><a href="http://www.methodintegration.com/method/kb.aspx?folder=MethodCRM&amp;article=How-to-delete-multiple-records-while-looping-through-a-grid&amp;id=194">delete multiple records article<span style="overflow:hidden;" id="mce_4_end"></span></a> in our Help Center.&nbsp; You can use the Start Loop Through Grid action to find each record in the table.&nbsp; Then you would have an Update Field on Table action that will take the value from your original field and put it in your new field.<br /><br />The import update is the easiest to do and would take the least amount of time.<br /><br />Greg<br /><br /></span></p>http://forums.method.me/cs/forums/thread/22779.aspxSat, 02 Aug 2014 13:53:39 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:22779micheleh0http://forums.method.me/cs/forums/thread/22779.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=22779<p><span id="mce_0_start" style="overflow:hidden;">I set up a field &nbsp;&#39;packsize&#39; and set it as text. then I imported the data and figured out it should be numberic so I can do math against it. &nbsp;Can I change the field type at this point? ifnot how do I correct this? canI setup new field and copy the data from one to the other?</span></p> <p></p> <p>Michele</p>