RIGHT expression

A

Amr

Hi,

Im using MS Access 2002, i made lots of quires depen on
the RIGHT expression, suddenly after we migrate to
diskless solution once i try to open the query a msg
appear " undefined function 'Right'in expression"

i don't know what is that and how can i sole it.

Amr
 
L

lobo

There is a problem with your VB references. You can either
use Right$() or, if that is what your using at the mo,
change it to Right()

If that doesn't work make sure your references are set-up
the same as when it was working
 

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

undefined function 'RIGHT' in expression 1
Expression using RIGHT and LEN functions 2
Undefined function 'concatenate' in expression 0
Undefined function 'Left' in expression 2
plz help !! Undefined function 'Date' in expression 2
Undefined function '[Right$]' in expression in a query after upgra 8
How can I use the Right([field],n) function in SQL query expressi. 1
Function Left/Right does work correctly in Access 2000. 2

Top