Help - Searching Memo Fields For Multiple Strings
if you need to search often - i suggest to make a "index" table - create a
new table and put each word on each memo filed to this table. then you can
make fast search on it
Quote:
> Hi, I just finished writing a module that will search Access 2K Memo
> fields for multiple occurances of strings. I am glad to have it working,
> however I am
> curious if there is another way. I tried a couple of examples using SQL
> and the "Like"
> command, but came to the understanding that in Access
> 2k, you cannot search the memo fields with SQL. If I am wrong, could
> someone point me the way. I'd be glad to confer with individuals as to
> the method of my solution - Thanks Todd
