The use of "Like"

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

I just want to make my query to look in the memo field name "Note1", the
records that has a content of "Jatimulia", but it seems it can not work.
Anyone can help me?.

This is my query:
SELECT *
FROM BukuAngKbyQuery
WHERE (((BukuAngKbyQuery.STAT_CODE)="A") AND ((BukuAngKbyQuery.Note1) Like
'*" Jatimulia & "*'))
ORDER BY BukuAngKbyQuery.NO_URTANGT;


Thanks in advance,

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the VBA 3
Find by Lastname does not work, until we click by Firstname, then 2
how cn we say it in query 8
Return only the numbers contained in a field 6
Query Result By Month 2003 1
Delete Records Where The Like* Can Be used?? 3
One Result from multiple memo fields 10
Parameter query does not show all data in memo fields with vbcrlf 7

Back
Top