Refer to query columns not by name ???

R

Ryan

I have a report based on a crosstab query.
My problem is that I don't know the column names the query
returns since they vary depending on an input parameter.

Is it possible to compose an access report without
referring to the column names anywhere????

I tried a million ways to change the query to output fixed
column names but could find any way to do it.

I am totally stuck at this point.
 
D

Duane Hookom

There is a very flexible solution at http://www.invisibleinc.com/. The site
seems to be down at the moment. You would need to navigate to the consulting
downloads. If you can't find this, come on back and I can probably get the
file posted elsewhere.

The solution requires you to create a report with a fixed number of columns.
The query will alias the column names with A, B, C, ... so they will always
be the same. If your number of columns exceeds your report design, the extra
columns are wrapped under the first group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access 2010 pivot table as subreport 0
Using select and crosstab queries on one report 1
Sub report based on Crosstab query 4
Crosstab Report 1
CrossTab report Access 2003 1
Crosstab report - handling Null fields 4
Mail Merge query 1
Report based on Crosstab Query 3

Top