Left, Mid, Right Function

[tcaprice]

The statment below worked for me in this database while the database was in Access97. Now that I've converted the database to Access2000, this query no longer works, I get the message:

Undefined Function 'Left' in expression.

SSN: Left([DUES].[SSN],3)+Mid([DUES].[SSN],5,2)+Right([DUES].[SSN],4)

Can anyone tell me why?

Thanks for your help.

Tom

 

[pdx_man]

It is a misleading error. In a code module, look under Tools ... References .... You will see that you have a missing library. It needs to be either loaded, registered or both.

 

[tcaprice]

Thanks for the help, followed your lead, problem resolved.

Thanks again.