SQL a Memo Field

[niteraven]

Hello all

I am having a bit of a problem with this line of code. I have a form that users input information and it produces a dynamic query. The like statement for the memo field is not working at all.

where = where & " AND [specialcircum] like " * " & " + Me![spcircum] + " & " * ""

and i have tried this way and about 5 other ways:

where = where & " AND [specialcircum] like "*" & '" + Me!spcircum + "'&"*""

Any help would be appreciated.
Thanks
Raven

 

[dhookom]

Remove a bunch of spaces and rearrange some quotes. Try:

where = where & " AND [specialcircum] like """*" &  Me![spcircum] & "*"""

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

where = where & " AND [specialcircum] like [blue]'*" & Me![spcircum] & "*'"[/blue]

Have fun.

---- Andy

 

[dhookom]

OOPS. I think I had one too many "s

where = where & " AND [specialcircum] like ""*" &  Me![spcircum] & "*"""

This should be the same result as suggested by Andy if the spcircum doesn't contain any apostrophes.


Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

And if the spcircum does contain any apostrophes:

where = where & " AND [specialcircum] like '*" & [blue]Replace([/blue]Me![spcircum][blue], "'", "''")[/blue] & "*'"

Have fun.

---- Andy