Compile error in query expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Do you mean references to tables? I'm not sure what you mean by references.

Thanks for your help
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Error msg - please help!! "Compile error. in query expression .." 1
AND in query expression 5
query expression compile error 1
Compile error. in query expression 1
Functions not working in Access 2007 Queries 9
Compile error in Query Expression 2
help in compile error 1

Back
Top