WHERE clause - Longshot

[shexe]

So I know this is an access forum, but I am pulling my hair out over an issue I am having with a WHERE clause in Excel...



I have a query in Access the uses WHERE ((([IT_Staff_Allocation_2010].ResourceName) Like "TBD *")) and it works just fine in access. When I attempt to link the query into Excel via Connection Properties I do not receive any results. After some trouble shooting I have determined that EXCEL does not like the Like "TBD*")) portion of the clause as it will work if I enter a known value (ex: lastname, firstname). EXCEL dislikes this so much that it wont call anything over even if I am calling the query as a table.

Is anyone aware of a different way to select records that begin with TBD?

[shexe]

...and I just realized I can use LEFT function. For anyone interested the below WHERE clause works.

WHERE LEFT([IT_Staff_Allocation_2010].ResourceName,3) Like "TBD"