Function Left/Right does work correctly in Access 2000.

D

dwcalhoun

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

Call function from query 'Criteria' line. 11
Date expression in Query 4
Sudden problem with functions in queries 2
Left String Function 2
InSrtRev function error 2
Format() function in Access 2003 4
Undefined Function error - Complex 3
InstrRev error 4

Top