Refer to query columns not by name ???

  • Thread starter Thread starter Ryan
  • Start date Start date
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.
 
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.
 
Back
Top