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))
 
Top