Results 1 to 2 of 2

Thread: Library

  1. 11-27-2006, 09:04 AM #1
    robbie1507
    robbie1507 is offline Registered User
    Join Date
    Nov 2006
    Posts
    1

    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.
    Reply With Quote Reply With Quote
  2. 11-27-2006, 11:03 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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%'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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