Undesired Crosstab character conversion

[LarryDK]

I am using a crosstab where the input table has periods (.) in the text field values which are being used as the column headings of the crosstab. Access is converting the periods to underscore characters, since a period is an invalid character in a column name.

Is there a way to retain the periods in the column heading, or is it possible to perform a "make table" so I modify the column headings.

Thanks for any help

Larry

 

[AccessDeveloper]

I think your own answer is the best way to go. Do a "make table" query, make a new valid table with valid field/column names, then run your crosstab.

 

[LarryDK]

OK, thanks. I'll work it from another point of view.