Data Type mismatch error while using Like in access query

[teco1]

Dear All

Need your support. I am getting Data type mismatch error while using Like in access query.
Below is my query and i have converted Final.QW and LTESITEID.LTEQW to Value by using VAL() Function to remove preceding zeros from them.



SELECT Final.SRC_CIFAST, Final.QW, Final.Switch1, Final.Switch2, LTESITEID.LTEQW
FROM Final, LTESITEID
WHERE ( [Final.QW] Like [LTESITEID.LTEQW]);

 

[james_lankford]

LIKE
works on strings

you might try
cstr( cdbl( [Final.QW] ) ) Like '*' & cstr( cdbl( [LTESITEID.LTEQW] ) ) & '*'

 

[teco1]

LIKE
works on strings

you might try
cstr( cdbl( [Final.QW] ) ) Like '*' & cstr( cdbl( [LTESITEID.LTEQW] ) ) & '*'

Still facing the same issue. Is there any other way to display the results where Both LTESITEID.LTEQW and Final.QW are same.

Thanks

 

[Joe4]

If you are checking for them to be the same, then use = instead of LIKE.

Also, why is there no join field between these two tables?

It might be helpful if you can tell us exactly what it is you are trying to accomplish, and maybe post some small samples of what the data looks like.

 

[teco1]

Thanks for your support. Actually the issue was with the original excel sheet which i was using as an input.
I changed its Column type to General and now its not showing Data Type Mismatch Error.