Re: Problem with field name that uses #

I have the solution for this when using one table:

Select [SS#] from MyTable

The problem is that I need to use aliases because I am using multiple tables
so:

Select [mt.SS#], ct.Lname
from MyTable mt, ChildTable ct

Does not work


"Striper" <jkaufmann@xxxxxxxxxxxxx> wrote in message
news:430b4170$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> I am trying to read from an access file that has a field named SS#.
>
> In my SQL select clause if I do not put double quotes around it, it will
not
> open. If I do the query opens but trying to access the field generates an
> error. Any suggestions for addressing this?
>
>


.