https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/53939.aspxWed, 21 Apr 2010 03:54:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53939Aruna Akella0https://www.infopathdev.com:443/forums/thread/53939.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=53939<p>Hi Bryan,</p> <p>You can do it by changing the SQL command in the data connection wizard - click on the &#39;Edit SQL...&#39; button in the data connection wizard, and enter the following command </p> <p>Select TOP 1 * from &lt;TableName&gt; order by &#39;Field1&#39; desc.</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/53931.aspxWed, 21 Apr 2010 00:50:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53931brjan9990https://www.infopathdev.com:443/forums/thread/53931.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=53931<p>Hi Everyone,</p> <p>Is there a way to set a field(s) to the last record of a database.&nbsp; Let&#39;s say that I have five database lines:</p> <p>ID&nbsp;&nbsp;&nbsp; Field1&nbsp; </p> <p>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A<br />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B<br />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C</p> <p>&nbsp;</p> <p>I want my field in infopath to query the database and pull the last value in the database, which in this case would be C.&nbsp; Any ideas?</p> <p>&nbsp;Thanks in advance,</p> <p><br />Bryan</p>