Left function problem???

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

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
 
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)
Click to expand...

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
 
Back
Top