(using the keyword As) the 'variable' field name to a Report) requiring fixed field name, and the crosstab. or for some other manipulation.Ī possible solution, in that case, is to create a query between the form (chart, Unfortunately, some 'fixed' names may be required for a form, a chart,Ī report. The values in the source table, producing the column name in the crosstab, are continuallyĬhanging. Sometimes, it is not possible to use a Fixed Column Headings with the crosstab because Give, even if a column is all empty, and it will produce ONLY those. Setting the Column Headings will force the XTab query to produce the columns names you
NOT get a column MAR, for March, and you WILL get an column MAC, probably full of NULLs. You just put in it the name of the columns you want to get, like 'JAN', If someone wants to fix column names produced by a crosstab query, they can use Column Headings property of such a crosstab ( from its property sheet, in design
