Is this SQL query right?

[just2cool]

I tried to put this in the query SQL but it doesn't seem to work. Any idea why?

Thanks!!

SELECT FTLookup.TransportationMode
FROM FTLookup WHERE FTLookup.Linehaul# = 'Legs.[1st Linehaul #]'

 

[just2cool]

Don't worry about it I got it. Thanks!

 

[Dennisk]

I would'nt use the # symbol as part of a column name, as it is infact a date delimeter. Nor would I start a column name with a number, nor would it contain spaces.

These are basic naming conventions that have evolved over the years.

 

[neileg]

You really shouldn't use # as part of your field name. # is used by Access as a date delimiter.

In fact you shouldn't use any punctuation or spaces in object names. It will, sooner or later, cause problems.