Microsoft Access – How To Limit # Of Characters Shown In Certain Field On A Query?
I do not want to change the actual data in the database, but can I adjust query output to show no more than 41 characters for a few fields that are pulling on a query?
You can use the ‘left’ function to return a specified number of characters from the left side of a string…
Format:
Left(string, length)
Example in a Query:
SELECT Left([Column A], 41) FROM [My Table]
The values in each row of Column A in My Table will be limited to 41 characters.