Compile Error

[Jay]

Hi,
I am trying to provide the user with an option to define some queries where
I am pulling a given number of characters using a build in fuction (left) but
I am getting the following error and I am not sure why. I will really
appreciate your help.

Compile error. in query expression'Left([AccountList]![Master Account
Name],[Forms]![Define Queries]![NoCharacters])'.

Thank you

 

[Ofer Cohen]

Usually there is a compile error in a query rearding build n function when
there is a missing reference

Open code (any where or press Ctrl+G), from the menu bar select Tools >
Reference - Check if the word Missing apear next to one of the obects
selected, if it does unselect it.

 

[Ofer Cohen]

Look at this link for addition explenation about missing reference

http://allenbrowne.com/ser-38.html