https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/7404.aspxMon, 08 Aug 2005 19:56:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7404Agni Jonnalagadda0https://www.infopathdev.com:443/forums/thread/7404.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7404Yes it is possible, you just need to change the command of the dataconnection if you want to change the query with which you getting the data from DB.<br />Here is how you can change the query of a DB data connection in code<br /><br />ADOAdapterObject oAdapter = (ADOAdapterObject) thisXDocument.DataAdapters["DatabaseConnectioName"];<br /><br />//Here you can write any code that you want.<br />oAdapter.Command = string.Format("select * from table1 where date1 &gt; date2 and date3 &lt; date2");<br />oAdapter.Query();<br /><br />Agni<br />InfoPath Dev Indiahttps://www.infopathdev.com:443/forums/thread/4838.aspxMon, 08 Aug 2005 18:15:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4838r107010https://www.infopathdev.com:443/forums/thread/4838.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4838I have a form connected to an access database. Is it possible to query information using multiple date ranges?