-
Library
Hi all,
Am new to Access but have created a small database with basic menu functionality. However, I have a query where I need to search on the description field of a table, but am I able to search on 'keywords' rather than the whole description?
For example: All items with '.NET' in their description field
If so, can you advise how?
Cheers,
Rob.
-
Access does not support full text indexing, so you can't do keywords search. You can only do LIKE search
select name
from table
where jobdesc like '%MANAGER%'