Problem with Wild Cards

[JoeandTel]

I have field called 'Details' it is of type 'Memo' I make
a query that says 'SELECT * FROM TableName WHERE Details
LIKE '*Ceiling Tile*'; I get a window that says it is an
invalid argument. I know that there are memos in 'Details'
that have 'Ceiling Tile' in it. What can I do?

 

[Jeff Boyce]

One approach would be to use the query design grid to build the comparable
query, then click on the design button (far left) and select SQL view to see
how Access builds it.

Good luck

Jeff Boyce
<Access MVP>

 

[joeandtel]

I actually did that and it still brought up the same
problem. I had someone in a yahoo group say that you
cannot search Memos.

 

[Van T. Dinh]

I use LIKE on a Memo Field without any problems (A2K). I think the reply
you got from yahoo is wrong.

The restriction on Memo Fields is that Memo Fields cannot be INDEXED.

When did you get the message? during execution of the Query or during the
design stage. If during execution, was the Query executed through the GUI
or by code? If by code, please post relevant code.