Compile error in query expression

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
 
O

Ofer

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

Compile error in table level validation expression in ms access office 2019 0
"Compile error in table level validation expression " after format 0
Error msg - please help!! "Compile error. in query expression .." 1
Sudden problem with functions in queries 2
Compile error in Query Expression 2
help in compile error 1
Functions not working in Access 2007 Queries 9
Repost-Edit and save query criteria 5

Top