Results 1 to 3 of 3
  1. #1
    aligahk06 is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Posts
    94

    Forms query first three char string match .

    Dear All,
    while applying the following criteria in query design view field [TenantName] gives all the records matching of three character anywhere in the string.
    Note : But i want it match only first three character and then return the only matching three character result.
    ex: Lacoste , lacruty , adhoclacry

    if i type lac it will only return all the string which match first three character lac.


    result expected :Lacoste , lacruty not adhoclacry

    Like "*" & Left([Forms]![WPQueryF]![TenantName],3) & "*"

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Remove that 1st asterisk.
    you don't want a wildcard in the front.

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Try:

    Like Left([Forms]![WPQueryF]![TenantName],3) & "*"
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-15-2018, 03:14 PM
  2. Replies: 3
    Last Post: 06-11-2016, 10:16 AM
  3. Oracle table name exceeds 30 char?
    By workindan in forum Access
    Replies: 0
    Last Post: 12-08-2010, 02:59 PM
  4. Getting first Char form a Field
    By newtoAccess in forum Access
    Replies: 3
    Last Post: 10-28-2010, 10:29 AM
  5. 8000 char max for memo?
    By okerix in forum Access
    Replies: 0
    Last Post: 04-29-2010, 08:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums