Weird??? Left Function not available in query??? 1

[jane30]

Hi, there!

I've been experiencing weird things recently, especially today when I created a calculated field:Left([field1],3) in my Select query. It returns me an error message: Function isn't availabe in expression in query expression. I've been using this function millions of times. All of sudden, it prohibits me to use it. Weird! I tried the same function in another database. It works perfectly.

Any idea?

Thanks a bunch in advance.

 

[JoeMiller]

Check your references. Go to a code window click Tools-->References and look for MISSING: Replace as necessary.

HTH Joe Miller
joe.miller@flotech.net

 

[jane30]

Thank you, Joe! It works fine now.