"Unidentified function" whe running 2000 Report in 2002

[Jim]

A Telephone Directory Report runs fine in Access 2000.
When I try to open it in Access 2002, I get the following
ERROR:

Unverified function 'Left' in expression

and can not open the Report in ANY view.

Looking at the report in 2000 "design view", the
function =Left([ResLN],1) appears in the ResLN header.
(That puts the A, B, C, etc. at the head of each "last
name" group.)

Im trying to switch over from an old computer running
Access 2000 to a new one running Access 2002. What to do?

Please help! THANKS!!!

Jim

 

[Jim]

SEE FOLLOWING CORRECTION TO MESSAGE!

A Telephone Directory Report runs fine in Access 2000.
When I try to open it in Access 2002, I get the following
ERROR:

Unverified function 'Left' in expression

Should read--->> Undefined function 'Left' in expression (SORRY!)

and can not open the Report in ANY view.

Looking at the report in 2000 "design view", the
function =Left([ResLN],1) appears in the ResLN header.
(That puts the A, B, C, etc. at the head of each "last
name" group.)

Im trying to switch over from an old computer running
Access 2000 to a new one running Access 2002. What to do?

Please help! THANKS!!!

Jim

Lord Henry

 

[Bruce M. Thompson]

A Telephone Directory Report runs fine in Access 2000.

Should read--->> Undefined function 'Left' in expression (SORRY!)

Sounds like a "references" issue. See the following page at Doug Steele's web
site for an explanation and various resolutions:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Jim W]

Thanks Bruce. That got me on the right track and the problem is
solved!!! thanks again.

Jim