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/17204.aspxThu, 16 Feb 2006 13:01:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17204ahardin0https://www.infopathdev.com:443/forums/thread/17204.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17204Hi<br /><br />Write a specific select query in your database and links its results to the form to pull up the results and hey presto, Job Done.<br /><br />I'm from WALES<br />adam.harding@ltsbasset.co.ukhttps://www.infopathdev.com:443/forums/thread/17203.aspxTue, 31 Jan 2006 14:51:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17203K.Ramana Reddy0https://www.infopathdev.com:443/forums/thread/17203.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17203Hi,<br /><br />Are you saving person1 name in access database if you save person1,<br />this is related to access than infopath.<br /><br />Thanks.<br /><br />K.Ramana Reddy<br />Infopath Dev Indiahttps://www.infopathdev.com:443/forums/thread/16780.aspxMon, 30 Jan 2006 13:32:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16780rowie0https://www.infopathdev.com:443/forums/thread/16780.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16780Hi I am very new at this so I need some help with a form that I am creating. <br />I have a form that allows the user to enter a start and end date range that the person requiring medication. This data is then saved into a access database. Is there a way of creating a form of a particular date that would tell me who is to have there medication. <br />Ie person1 takes medication from the 01/02/2006 till 20/02/2006.<br />If I run the report on the 11/02/2006 person1 will be in the report. <br />