Left function problem???

[fishqqq]

For some reason my home copy of access2003 wont let me use the
following criteria in a query but it seems to work fine at the office.
the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION.
There must be a setting that needs to be done ??? (i just installed the

home copy and it's the exact version that's on the office computer.

Any help is greatly appreceiated.


expression= 1: Left([company],20)


Tks

 

[Dirk Goldgar]

For some reason my home copy of access2003 wont let me use the
following criteria in a query but it seems to work fine at the office.
the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION.
There must be a setting that needs to be done ??? (i just installed
the

home copy and it's the exact version that's on the office computer.

Any help is greatly appreceiated.


expression= 1: Left([company],20)

Often when databases don't work on one particular machine, it's because
of a broken or missing reference. See if the steps outlined here help:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[fishqqq]

perfect!

tks
Steve