Results 1 to 2 of 2
  1. #1
    velvettiger is offline Novice
    Windows XP Access 2000
    Join Date
    Mar 2010
    Posts
    5

    Counting Characters in a text field

    Hi everyone,



    I am trying to return the personal information of those customers who have id numbers greater than or equal to 10.
    Oh, and the ID field is a string.

    Any ideas?

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Use the "Len" function:

    Code:
    Len([IDfieldName])
    Cheers,

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

Similar Threads

  1. split text field
    By Zukster in forum Queries
    Replies: 4
    Last Post: 01-11-2011, 10:01 PM
  2. Setting a field to only accept text characters, not numbers
    By USAFA2012 in forum Database Design
    Replies: 2
    Last Post: 03-09-2010, 12:37 PM
  3. Replies: 3
    Last Post: 12-15-2009, 01:47 PM
  4. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 AM
  5. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 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
  •  
Other Forums: Microsoft Office Forums