Query Left - limit by characters but bring whole word

[JoeAccessHelp]

Hi Access experts,

If there a function that would limit the returning data by the number of characters but still bring back the nearest whole word.

I'd imagine doing this on excel I would use a mixture of LEFT LEN & SEARCH. However, I cannot figure this one out on Access.

e.g. Description column has 'Singapore Style Sofa with local fabric' I want to limit to 18 Characters but want to return the whole word ('Sofa' no just 'So')

Any help would be greatly appreciated

Thanks
Joe

 

[Ranman256]

no function. It would take some vb programming.

 

[PeterF]

Use functions left and instr like:

Left([yourfieldname];InStr(18;[yourfieldname];" ")-1)

Depending on country settings replace ";" by ",".