Crosstab changes periods

[d33]

Hi all. Have any of you ever had this happen? I have a
text field that is part of a crosstab query. And it is the
column value. In this case, it is the consultant's name.
For instance, P.E.L.A. Well, the crosstab takes my periods
and changes them to underlines, like this P_E_L_A_. This
of couse is messing up my table calculations, not to
mention that it looks bad. Any ideas? Oh, the text field
is a text type.
thanks,
dan

 

[david epsom dot com dot au]

Yes, it does that. Column names cannot have 'periods' in
them, because 'periods' delimit column names:
DatabaseName.TableName.FieldName

You can use REPLACE (or a UserDefined function) in your
select query to replace all the periods with something
else (spaces?) if you don't like underscores.

(david)

 

[Guest]

I didn't think of that. Can you force it somehow?
Someone had suggested something like Cstr(<FIELD_NAME>).
I've never done that and don't even know how, but I'm
guessing your right. I'll just have to think of another
way to do it. Thanks for the help.
dan

 

[Guest]

Figured it out. In the Format section I used the Replace
command and just had it switch the '_' for a '.'. Works
great.
thanks for the help!
dan