Hello Guys,

I am using Access 97. Do you know If I can use the function RIGHT in the SQL syntax. And If, how ?

Thank you in advance. :)

Yes, you can do it.
Look at "DemoQueryRightA97.mdb" (attachmnt, zip).
Look at query1, column Expr1.

attachment here.

Respect !


hvala ti. (I guess is right) :)