Function Left/Right does work correctly in Access 2000.

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?
 
R

Rick B

How excatly are you using them? They work fine for me.

LastFourOfSocial: Right([SocialSecurityNumber],4)


Rick B
 
D

Duane Hookom

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
Mid$, Right$ error message. 1
Why I can't use format, Left and Right function in a query? 2
Functions in Access 2000 queries 2
Undefined function 'Left' in expression 2
Undefined function 'Format' in expression 1
Undefined function '[Right$]' in expression in a query after upgra 8

Top