Data Type mismatch error while using Like in access query

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]);