InfoPath Dev

Hello-

I am trying to use the results of a cross tab query from my Access 2003 database and display them in an Infopath 2003 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 from my Access database. It will only recognize the Select queries or the tables. So my questions are:

1. Are cross tab queries not allowed in a connection?

2. And if I they are, can someone please tell me how to do this?

Thanks in advance.

RhysAZ 

Hello again, 

Can someone please answer my question?

I'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:

Error Name                             Jan         Feb     Mar      ....        Total

Incorrect Id                               4           10        7                     21 

Incorrect Name                         2             1        8                     11

I'd like to do this in a repeating table if possible.

Thanks,

RhysAZ