Hello Sir's & Ma'ams
I need Help is there a way to get the 1st word or if i want a specific word to display in Report when i generate it?
and btw some of the words are not the same and also in the same page of the report. like for example
Car All Types - i only want Car All to Display in Report
Heavy Equipment - i only want Heavy to Display in Report
Motorcycle - i want only Motor to display in report
etc.. etc.. there are many more
i tried using this in unbound text in the Report
but other words like Motorcycle and Heavy Equipment are not the same length as Car All Types
please help me thank you and Happy New Year!
I need Help is there a way to get the 1st word or if i want a specific word to display in Report when i generate it?
and btw some of the words are not the same and also in the same page of the report. like for example
Car All Types - i only want Car All to Display in Report
Heavy Equipment - i only want Heavy to Display in Report
Motorcycle - i want only Motor to display in report
etc.. etc.. there are many more
i tried using this in unbound text in the Report
Code:
=left([Type],13)
please help me thank you and Happy New Year!