Crosstab Query Headers

[Bchemist]

I have a crosstab query which pulls version numbers for a specific report. i.e.


Client A_3.1 A_3.2 A_3.21 B_4.0
A x
B x
C x

etc...

everything works fine, except the decimals are converted to underscores. i.e.

Client A_3_1 A_3_2 A_3_21 B_4_0

I need to know if there is a way to force the decimals in or replace generate the column headers with a different character than the underscore, since I can do a string replace on the final report for an unused charaters. Since some of my titles have legit underscores in them, I can not do a string replace of the underscores to decimal.

Is there a way around this?

 

[PaulRAmes]

Bchemist,
You could try specifying the header names in the crosstab query by right-clicking in the upper panel and typing in the names you want in the header section i.e. "A_3.1","A_3.2", etc. But remember, Access uses the . to separate table names from field names in query headings.
Paul