Update query not working and error msg is strange

[Colleyville Alan]

I am trying to run an update query to take information in a field and remove
the last 4 chars. For example, the following piece of data: [CTF]DAA1.CTF,
should be converted to [CTF]DAA1 (without the ".CTF"). I have use the
"Update to" command:

"Left([test].[ticker],Len([test].[ticker]-4))

with criteria of Like "*.CTF"

I get a message saying Access cannot convert the data due to a type
conversion error. I am confused by this. The values are currently text and
stripping off the last 4 chars will not convert the data to another type.
So I have two questions,
1 - how do I fix this and
2 - why am I getting this strange error msg?
Thanks

[Nigel tombs]

You have the Len close bracket in the wrong place.
should be :
Left([test].[ticker],Len([test].[ticker])-4)


"Colleyville Alan" <ae***********@nospam.comcast.net> wrote in message
news:R1zQb.112048$5V2.519194@attbi_s53...

I am trying to run an update query to take information in a field and remove the last 4 chars. For example, the following piece of data: [CTF]DAA1.CTF, should be converted to [CTF]DAA1 (without the ".CTF"). I have use the
"Update to" command:

"Left([test].[ticker],Len([test].[ticker]-4))

with criteria of Like "*.CTF"

I get a message saying Access cannot convert the data due to a type
conversion error. I am confused by this. The values are currently text and stripping off the last 4 chars will not convert the data to another type.
So I have two questions,
1 - how do I fix this and
2 - why am I getting this strange error msg?
Thanks

[Colleyville Alan]

"Nigel tombs" <ic*****@tiscali.co.uk> wrote in message
news:40********@mk-nntp-2.news.uk.tiscali.com...

You have the Len close bracket in the wrong place.
should be :
Left([test].[ticker],Len([test].[ticker])-4)

Thanks, that works.