using the len expression in query pane

[nevstic]

good evening all
would anyone please be kind enough to show me how to use the Len expression in a query pane
I Have so far this much


expr:len([name])
but I would like to show only the first 4 characters in the query result, so far I only get the number of names

thanks
nicky

 

[HBWAL]

len returns to number of letters in whatever you put in the ().

if you want the first 4 chars then try left([fieldName], 4)

 

[willir]

Also look at
RIGHT
MID

Use Access help for syntax.

 

[nevstic]

many thanks for your quick reply
now it works for me !

Rgds
Nick