Compile error in query expression

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi all,

I have a "Compile error in query expression" when I tried to run a query.
I initially had a problem with invalid procedure call in my Access 97
database,
John Vinson(MVP) help me resolved that, thank you John.
But now I have this error.
I query used a CInt() function like: CInt(NumberInTextFormat), in my query
and it stops.

Please help. Thank you for sharing your thoughts.

Ben
 
Check that the field NumberInTextFormat doesnt contain other char but
numbers, or nulls.
if it contain nulls then write cint(nz(NumberInTextFormat,0))
 

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

Access #Error & Excel Pivot 0
Use In() Expression as Query criteria with guts from Function 1
Error msg - please help!! "Compile error. in query expression .." 1
Compile error in Query Expression 2
Compile error. in query expression 1
query expression compile error 1
Compile error in query expression 3
Undefined Function Error 6

Back
Top