Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Question Unanswered: Query - Limit Characters Displayed

    Hello All,
    I am trying to create a query in Acess that will only show the first 100 characters of a specific field.

    For example:
    Query Fields
    ID
    Title
    Details

    I would like for ID and Title to appear as is in the query, but for Details I only want to display the first 100 characters.

    Any ideas on how to do this would be greatly appreciated.
    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Use the Mid function for the details field in the query.
    Saludos
    Norberto

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    left() would be better.

    SELECT LEFT([Details], 100) AS Details

Posting Permissions

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