Use Of ":" In Query As Part Of Header

  • Thread starter Thread starter Clint
  • Start date Start date
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
 
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]
 
Back
Top