Building a report off a query with dynamic column and criteria prompts

[accessaspire219]

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.

 

[HiTechCoach]

This may help:

Dynamic Report based on a Crosstab query

 

[accessaspire219]

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.