Left function does not work in 2000

[John Barry]

Help please. We run an access database created in access
97. one small function was to take a field which contained
4 figure numbers and using the funcion Left we could list
just the first two characters of the field for grouping
purposes. When we have converted to Access 2000 the
expression no longer works, and when I have re written the
expression using the expression builder it still reports
an error. Any suggestions please

Thanks

John

 

[Jeff Boyce]

John

Left() is a built-in function. If it isn't working, Access has a "MISSING"
reference.

Open a module, select Tools|References, uncheck any prefixed with "MISSING",
and close/save. Re-open and re-check, close/save.

You probably need to recompile after this, and do a compact/repair.

Good luck

Jeff Boyce
<Access MVP>