Function Left/Right does work correctly in Access 2000.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the functions Left / Right in a query and get a message "undefined
function in expression". These functions work OK in Access 97, but do not in
Access 2000. What is different?
 
How excatly are you using them? They work fine for me.

LastFourOfSocial: Right([SocialSecurityNumber],4)


Rick B
 
This is nearly always a references issue.
www.google.com/search?q=Access+Undefined+Function+Expression

--
Duane Hookom
MS Access MVP
--

Rick B said:
How excatly are you using them? They work fine for me.

LastFourOfSocial: Right([SocialSecurityNumber],4)


Rick B


dwcalhoun said:
I am using the functions Left / Right in a query and get a message "undefined
function in expression". These functions work OK in Access 97, but do
not in
Access 2000. What is different?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Left String Function 2
Undefined function 'Left' in expression 2
Mid$, Right$ error message. 1
Undefined function 'concatenate' in expression 0
"undefined function 'Right' in expression" 2
Why I can't use format, Left and Right function in a query? 2
Undefined function 3

Back
Top