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/9089.aspxThu, 23 Feb 2006 01:48:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:9089Shanthi Reddy0https://www.infopathdev.com:443/forums/thread/9089.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=9089Yes you should be able to do the same in InfoPath also. It depends on your database. Just create a SQL query data connection using the SQL command that returns all 7 days of data. Now drag drop all the data fields into the view. When you preview you should be able to see the data for all 7 days.<br /><br />Shanthi<br />InfoPath Dev Indiahttps://www.infopathdev.com:443/forums/thread/5363.aspxWed, 15 Feb 2006 21:24:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5363Paradice290https://www.infopathdev.com:443/forums/thread/5363.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5363Hi,<br /><br />I have an order system that I created in Excel that I want to port over to Infopath. In the Excel form our stores can order for all 7 days of the week on one sheet. Can I do the same thing in Infopath? How would I query that database to display all seven days at once? Any ideas.<br /><br />Thanks!