Use Of ":" In Query As Part Of Header

C

Clint

I have a query with a field name of "Street", however, I would like it
to read "CAT:STREET".

This query is exported to a csv file the requires the format of the
later. Currently the csv file is modified manually afer the fact.

In the query I have been unable to create an expression that does not
choke on the ":".

Any suggestion as to how allow this in the query, or maybe allow this
in the export.

Thanks in advance
 
J

John W. Vinson

Hi Clint,
You won't get that fixed. Can't you use as header CAT_STREET:

Cloggy
Click to expand...

Can you set the Caption property of the field Street to CAT:STREET?

John W. Vinson [MVP]
 
Top