I have a field that has for example content "110 Ellip" which is being pulled from our database and cannot be changed.

 

I only want to show the "110" in the field on the report.

 

I am trying to use:

 

left({tablename.fieldname},3)

 

However keep getting an error about the selection must be a boolean.

 

An I heading down the right path here?

 

 

Thanks in advance

Stephen

 

({tablename.fieldname} [1 To 3]

 

What is inside the square brackets determines what part of the string it extracts by character position.