limit character count

[fishqqq]

Please show me how to limit the character count to a specific # once a
query is run.

For example if a query provides a list of customers for me but some of
the customers' names are too long for this data to be useful - i would
like the query to also shorten the names to a maximum of 20 charactors.
whereas the company "ABC International Limited" would be displayed as
"ABC International Li".

Please note i don't want the query to limit the search to companies
with only 20 characters in their name - rather give me all the
companies and display their name to the 20th character only.

any suggestions are greatly appreciated.

 

[fredg]

Please show me how to limit the character count to a specific # once a
query is run.

For example if a query provides a list of customers for me but some of
the customers' names are too long for this data to be useful - i would
like the query to also shorten the names to a maximum of 20 charactors.
whereas the company "ABC International Limited" would be displayed as
"ABC International Li".

Please note i don't want the query to limit the search to companies
with only 20 characters in their name - rather give me all the
companies and display their name to the 20th character only.

any suggestions are greatly appreciated.

Add a new column to the query.
ShortName:Left([CompanyName],20)

Perform your search in the [CompanyName] field.