Results 1 to 2 of 2
  1. 01-19-2012, 06:38 PM #1
    taimysho0
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    how to search only CERTAIN strings in a field??

    hello i have a column that users write columns in, how do i get the query to only filter fields that have the word "due" in it?

    i tried Like "due" in criteria but it doesnt find anything,. thanks
    Reply With Quote Reply With Quote
  2. 01-19-2012, 07:05 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,600
    Use wildcard: Like "*due*"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Complex search through strings in records
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 03-17-2012, 11:25 AM
  2. Search for a field in a table and return a seperate field in the same record
    By desk4tbc in forum Programming
    Replies: 3
    Last Post: 08-26-2011, 12:11 PM
  3. Delete Specific Text Strings in a Field
    By JET in forum Queries
    Replies: 5
    Last Post: 08-25-2011, 03:33 PM
  4. combining multiple fields and comma delimi as strings into one field using update
    By johnmerlino in forum Access
    Replies: 15
    Last Post: 10-14-2010, 12:22 PM
  5. Search in the navigation bar to search only a specific field ?
    By Grooz13 in forum Forms
    Replies: 2
    Last Post: 08-31-2010, 08:57 PM

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

Other Forums: Microsoft Office Forums