SQL condition -- LIKE in multivalue field of Access 07

[beemomo]

Hi everyone there, i am facing the problem with using the SQL condition --LIKE in a multi value field of my access 07 table.

I have a multi value field which store a number of keywords for a particular document, named as Keywords.

I need to find out which document contains a particular keyword, for example: i want to know all the documents which contain a keyword of "Ventilation".

My SQL statements sound like this:

SELECT ID, Document_Name, Author, Keywords.Value
FROM Document
WHERE Keywords.Value Like '*Ventilation*';

Is this making any sense? Hope to hear from you guys soon , many thanks!

[beemomo]

hi there everyone, i found the solution, i should use the bound value instead of the display value of the multivalue field in the LIKE statements.