3075 error in query expression with LEFT and RIGHT function

[babu]

Hi All,
I need your help on this.
In my Access 97 m/c, when i am running a query as
select * from tbl_xxx where LEFT(field1,10) = "text 1" and right(field2,10)="text 2".

While running i am getting the Error as :

3075 function is not availabale in expressions in query expression LEFT(field,10) = "text 1"

Please can you let me know what are the libraries in the references i should add to get rid of this error.

Thanks a lot for all your help in advance.

 

[khawar]

What is the "text 1" is it a field or a text

 

[babu]

Text 1 is a text say "abc".

 

[khawar]

Your Sql should work

 

[babu]

Hi khawar,
Thanks for your reply. I didn't get your answer. Please can you tell me in more detail.

 

[boblarson]

Shouldn't it be
LEFT(field1,6) = "text 1"

 

[babu]

It's a copy paste error, sorry about that.
the code is : WHERE LEFT(Reason,10) = "Range Tail" . It working fine in the production i.e. in tehuser PC. But when trying to run the same thing ibn my PC it's giving thsi error.

Please can you help.

 

[boblarson]

Probably a reference error.
http://www.btabdevelopment.com/main...eckformissingreferences/tabid/71/Default.aspx

If none are labeled MISSING, uncheck the DAO reference and then close the dialog and then reopen and check it again.

 

[babu]

Thanks a lot Bob.
It's working fine now.