https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17223.aspxTue, 23 May 2006 16:07:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17223sscarcella0https://www.infopathdev.com:443/forums/thread/17223.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17223Can you post your example? I am trying to query between two dates and having trouble.https://www.infopathdev.com:443/forums/thread/17222.aspxTue, 21 Feb 2006 12:48:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17222ahardin0https://www.infopathdev.com:443/forums/thread/17222.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17222Hi Agni<br /><br />Sorted it through a suggestion from Ms SYM Wong-A-Ton<br /><br />Use my query to assign a record in one date range to have an identifyer 1, second date range 2, 3rd date range 4 and so on.<br /><br />Then use DDList box to select the date range from text descriptions that links to either 1 2 3 or 4 Job done.<br /><br />I'm from WALES<br />adam.harding@ltsbasset.co.ukhttps://www.infopathdev.com:443/forums/thread/17221.aspxFri, 17 Feb 2006 19:27:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17221Agni Jonnalagadda0https://www.infopathdev.com:443/forums/thread/17221.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17221Hi Adam,<br />Can you paste your query here please? <br />Are you able to getting all of the results when you run this query on the Database side?<br /><br /><br />Agni<br />INFOPATHdev Indiahttps://www.infopathdev.com:443/forums/thread/17220.aspxFri, 17 Feb 2006 15:02:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17220ahardin0https://www.infopathdev.com:443/forums/thread/17220.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17220Anyone hepl on this at all, please?<br /><br />I'm from WALES<br />adam.harding@ltsbasset.co.ukhttps://www.infopathdev.com:443/forums/thread/16786.aspxThu, 16 Feb 2006 11:26:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16786ahardin0https://www.infopathdev.com:443/forums/thread/16786.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16786Hi all<br /><br />Have written access queries to pull of all results falling between two dates using the dateadd function. When i connect these queries to my infopath form i want it to reutrn all results like it does in the select query, but it only returns the first result.<br /><br />I feel so close but so far and cannot get this to work. Anyone got any ideas?<br /><br />Cheers Adam