• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5133
  • Last Modified:

truncate a text field in an access query

In an access query I would like to display only the first 20 characters of a 40 character text field. I don't want to change the size of the field in the underlying table just display the first 20 in the query display. Is there a command for text fields similar to the format([number field],"0.00") command for number fields?
0
Robert Wardlow
Asked:
Robert Wardlow
  • 2
1 Solution
 
Patrick MatthewsCommented:
Left([fieldname],20)
0
 
Patrick MatthewsCommented:
SELECT Left([fieldname], 20) AS Truncated
FROM SomeTable
0
 
Robert WardlowPresidentAuthor Commented:
excellent, thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now