Data Type mismatch error

[fd1]

Hi All,
I'm getting Data Type Mismatch error when I run the following query:

SELECT tbl1.Definition, tbl2.Group
FROM tbl1, tbl2
WHERE ((Mid$([tbl1]![Definition],6)=Mid$([tbl2]![Description],9)));

Both "Definition " and "Descriptio n" are of type text.

[fd1]

Never mind, I just had to use Mid() instead of Mid$()