-
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%'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|