+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Access - Query in Technical; I have a have a query which brings me up all the rows that have an entry in so I ...
  1. #1

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,167
    Thank Post
    12
    Thanked 224 Times in 214 Posts
    Rep Power
    66

    Access - Query

    I have a have a query which brings me up all the rows that have an entry in so I created a criteria of Is Not Null which shows this, within the same column I only want to show the rows if the do not have 17 characters in, some will have more some will have less.

    Any ideas how to do this?

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,689
    Thank Post
    334
    Thanked 515 Times in 483 Posts
    Rep Power
    179
    As in, everything below 17 chars but not empty?

    Code:
    SELECT * FROM MyStuff WHERE string IS NOT NULL AND Len(String) < 17
    as an example

    Or did I msunderstand?

    Edit - If you mean anything but 17 this should do it

    Code:
    SELECT * FROM MyStuff WHERE string IS NOT NULL AND Len(String) <> 17
    as an example


    Steve
    Last edited by Steve21; 25th September 2012 at 05:00 PM.

  3. #3

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,167
    Thank Post
    12
    Thanked 224 Times in 214 Posts
    Rep Power
    66
    This is what I have the query set to at the moment:

    Query.JPG

    Under the criteria I have now I want a bit that will show anything that isn't 17 characters in length, so less and some more but as an end result on that query I only want ones more or less than 17 and that have data in them.

    I did try that one you gave me but it would not work, unless I was doing something wrong.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2010] Access Query - Update SQL statement Help please
    By RabbieBurns in forum Office Software
    Replies: 2
    Last Post: 26th July 2012, 08:14 AM
  2. Unofficial Accounts/Access query
    By LeMarchand in forum Office Software
    Replies: 1
    Last Post: 5th May 2011, 03:24 PM
  3. [MS Office - 2007] Access Query Date/Time
    By linkazoid in forum Office Software
    Replies: 5
    Last Post: 18th March 2010, 03:48 PM
  4. [MS Office - 2007] MS Access query help
    By randle in forum Office Software
    Replies: 7
    Last Post: 9th November 2009, 01:17 PM
  5. [MS Office - 2003] Access Queries
    By Jamo in forum Office Software
    Replies: 2
    Last Post: 13th March 2009, 09:49 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •