Results 1 to 2 of 2
  1. 08-27-2020, 08:09 AM #1
    fishhead
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167

    filtering string length

    How can i filter a field that only has a string length of 5? Some of the records have a string length of 8 and i don't want these in my query results?



    thanks in advance! : )
    Reply With Quote Reply With Quote
  2. 08-27-2020, 08:12 AM #2
    isladogs's Avatar
    isladogs
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Add a filter clause Len([FieldName])=5
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Checking if a character in a string exists at the end of a variable length string and replacing.
    By NightWalker in forum Programming
    Replies: 3
    Last Post: 07-20-2020, 01:04 PM
  2. cannot be a zero-length string
    By MadTom in forum Forms
    Replies: 5
    Last Post: 03-09-2020, 07:52 AM
  3. Field Cannot Be A Zero Length String Error
    By VSCurtis in forum Programming
    Replies: 6
    Last Post: 05-09-2017, 10:52 PM
  4. Inverted Left function - how to exclude string with variable length
    By DSam in forum Import/Export Data
    Replies: 7
    Last Post: 09-23-2016, 01:04 PM
  5. I can't get the DIR function to return anything other than a zero length string
    By GraeagleBill in forum Programming
    Replies: 6
    Last Post: 01-21-2014, 06:39 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