https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/41256.aspxMon, 04 May 2009 21:40:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41256RhysAZ0https://www.infopathdev.com:443/forums/thread/41256.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=41256<p>Hello again,&nbsp;</p> <p>Can someone please answer my question?</p> <p>I&#39;m trying to display the count of error names that the user selected, by month, by using a crosstab query I created in my database. Such as:</p> <p>Error Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total</p> <p>Incorrect Id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;21&nbsp; </p> <p>Incorrect Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</p> <p>&nbsp;</p> <p>I&#39;d like to do this in a repeating table if possible.</p> <p>&nbsp;</p> <p>Thanks,</p> <p>RhysAZ&nbsp;</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/38426.aspxFri, 13 Feb 2009 22:49:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38426RhysAZ0https://www.infopathdev.com:443/forums/thread/38426.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=38426<p>Hello- </p> <p>I am trying to use the results of a cross tab query from my Access 2003 database and display them in an Infopath 2003&nbsp;form. The problem is when I go through the data connection wizard and I get to the part about selecting the table or query as my main source (or even as a secordary source) it does not recognize my cross tab query&nbsp;from my Access database. It will only recognize the Select queries or the tables. So my questions are:</p> <p>1. Are cross tab queries not allowed&nbsp;in&nbsp;a connection?</p> <p>2. And if I they are, can someone please tell me how to do this?</p> <p>Thanks in advance.</p> <p>RhysAZ&nbsp;</p> <p>&nbsp;</p>