Robert Wardlow
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent, thanks
FROM SomeTable