Query result: Data type mismatch

Where do you get the error?

Does that query run when you try and execute it manually in the database?

Does the database you are querying support the functions CLng and Val?

It doesn't run coz' the query seems incorrect. Yes, access database support CLng and Val functions.

The original code was: (It is in MySQL script)

Please Login or Register  to view this content.

My problem in that code is that Cast function is not supported in ms access and I've search in the internet that CLng, CInt and Val functions can substitute for Cast, but unfortunately, it still gives me an error

for the below code

Please Login or Register  to view this content.

i've converted it to CLng or CInt, but still it doesn't work.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Why are you using Val and CInt?

Have you tried just using one of them?

Also, what happens if you don't use either of them?

Where exactly do you get the error?