Use of ":" in Query Fieldname

am 12.10.2007 16:28:22 von Clint Stowers

I have a query that I export as a csv file.

The problem is I want to create a Fieldname such as "CAT:STREET" from
a field currently named "STREET"

For obvious reasons it don't like the placement of the ":". Any
thoughts as to a work-around?

Thanks in advance.

In the meantime I'll just go in and rename the field after it's
generation.

Re: Use of ":" in Query Fieldname

am 12.10.2007 16:53:05 von Tom van Stiphout

On Fri, 12 Oct 2007 07:28:22 -0700, Clint Stowers
wrote:

How about CatStreet?

Otherwise use square brackets.

-Tom.

>I have a query that I export as a csv file.
>
>The problem is I want to create a Fieldname such as "CAT:STREET" from
>a field currently named "STREET"
>
>For obvious reasons it don't like the placement of the ":". Any
>thoughts as to a work-around?
>
>Thanks in advance.
>
>In the meantime I'll just go in and rename the field after it's
>generation.

Re: Use of ":" in Query Fieldname

am 13.10.2007 02:51:39 von Harvey Thompson

Clint Stowers wrote:
> I have a query that I export as a csv file.
>
> The problem is I want to create a Fieldname such as "CAT:STREET" from
> a field currently named "STREET"
>
> For obvious reasons it don't like the placement of the ":". Any
> thoughts as to a work-around?
>
> Thanks in advance.
>
> In the meantime I'll just go in and rename the field after it's
> generation.

Clint;

See: Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/kb/826763/

Harvey