Hi,
I have a cross tab query and a query after the cross tab query that uses MyCrossTabQuery.* in the SQL to select all the columns, since the columns are months and every month a new month will be added and I want that new month to be automatically included.

Now, I have a few of these queries uniting to form a summary query which is basically a union query.

I would like to build a report of this query, but when I select this union query in tables/queries as a source to my report, none of the query columns are displayed for selection on the report.

Can anyone help me out with this?

Also, my query has a form through which the user enters critera, thus some columns point to fields on the form for the criteria, prompts for entering criteria (paramenter value) keeping coming up when I am trying to edit a report (that I built earlier) off this same query. Is there a way to turn this off?

Thanks.

This may help:

Dynamic Report based on a Crosstab query (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=6&Itemid=28)

Hi Hitech,
In the RptCrosstab2k database you have a report which has a number of unbound textboxes in the report. What is the control source for these text boxes? I mean what tells them "where to pull data from?"
Thanks.