Compile error in query expression

[GarryT]

Can anyone tell why the following function "trim(contract) as tcontract" in
an sql statement gives me the following error; "Compile error in query
expression"? I am sure this should work, but I can't seem to get in to work.

Thanks in Advance,
Garry

 

[Jon Ley]

Check your references. Very often if you have a broken reference you will
find that standard Access functions will generate errors. The functions that
generate the errors can be completely unrelated to the object model of the
broken reference.

 

[GarryT]

Do you mean references to tables? I'm not sure what you mean by references.

Thanks for your help

 

[Jon Ley]

I mean object library references. Open any code window (view the code behind
any form or report, or open any module, or even just press Ctrl-G - this will
open the Visual Basic code window). From there, go to the Tools, References
menu and look for any ticked items that report as MISSING.