> I am querying a table on a MS SQL Server 6.5. One of the field names
> contains a space i.e. DATE OPEN.  How do I reference this in my query
> string?

> I queried the same table using a field that does not contain spaces and it
> works.

> > I am querying a table on a MS SQL Server 6.5. One of the field names
> > contains a space i.e. DATE OPEN.  How do I reference this in my query
> > string?

> > I queried the same table using a field that does not contain spaces and
it
> > works.

> Have you tried putting the name in brackets: [DATE OPEN] ?  This works
> when running an SQL query on Access db's.

> --
> Jim in Cleveland
> If you're writing to me, in my address
> change "REAL_Address.see.below" to "worldnet.att.net"

> "What's so funny 'bout peace, love & understanding?"
>      - Nick Lowe

> I tried the brackets and it did not work. I am working with an ADO Data
> Control. I am putting these queries under the record source tab. When I
> enter the query syntax with the brackets, I gives me an error.

> > I tried the brackets and it did not work. I am working with an ADO Data
> > Control. I am putting these queries under the record source tab. When I
> > enter the query syntax with the brackets, I gives me an error.

>   Well, ain't that annoying?  I've seen another syntax for refering to
> fields with quotes within parentheses: ("DATE OPEN") - so you could try
> that style.  If that ain't it, I'm no help at all.  Another hard-knocks
> lesson:  why field names shouldn't have spaces.  Good luck!
> --
> Jim in Cleveland
> If you're writing to me, in my address
> change "REAL_Address.see.below" to "worldnet.att.net"

> "What's so funny 'bout peace, love & understanding?"
>      - Nick Lowe