[AccessD] Fixed header names in crosstab query

Hi Erwin

You will have to either build the complete SQL in code or modify the
SQL property of an existing query to create the "IN (...)" clause you
need.
I have found no other method.

/gustav

>>> Erwin.Craps at ithelps.be 04/13 3:31 pm >>>
When using a crosstab query the colomnheaders get the name of a
specific
data in a field.
When there is no data for a specific column the column is not
displayd.
IF you know that the number of columnrecords is fixed, like days for
example 1 to 31, you can add 1...31 in the column text of the
columnheader property.
As a result there are always 1 tot 31 headers (fields) even if no data
is present.
 
 
But Now I'm in the situation that I have activity codes in the
columns,
which are in a sub table.
How can I still do this trick but based on data in a table? Can I do
some kind of SQL insert into this columnname property?