By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

Update query not working and error msg is strange

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a

"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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.