Change query header

  • Thread starter Thread starter Felix
  • Start date Start date
F

Felix

Can the header of a query datasheet be changed. I'm trying
to replace where the query name is printed with a user
defined title. If this isn't possible please read the
question below.

I've created a crosstab query that is based on a temporary
table which changes depending on user input into a form.
The reason is that I was asked to produce a report that
sorts data accross the top and down the side plus filters
for given criteria for the column header. Now if I try to
base a report on this crosstab query it clearly returns
fields with the names of the filtered column header data.
I need this to be dynamic and change depending on what the
user wants. Currently I can't find a way to do it
therefore I was simply going to print the crosstab query
in datasheet view and call that the report (ugly I know
hence the question above). Is there any other way to do
what I'm trying to accomplish?

Your help is most appreciated.
 
Hi,


You can, technically, supply an alias. Can't you make a runtime query
that would alias each fields for the crosstab?


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top