var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query - Limit Characters Displayed
I am trying to create a query in Acess that will only show the first 100 characters of a specific field.
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.
Use the Mid function for the details field in the query.
left() would be better.
SELECT LEFT([Details], 100) AS Details