You need to show me the *ACTUAL* query you are using, not showing me etc.
That error message means that you are trying to match the value of a numeric database field with a non-numeric test value, or vice versa, or or or...
SELECT * FROM tablename WHERE amountOfMoney = 'frammis'
Presumable the field named amountOfMoney
is a numeric field. In which case the database engine is expecting you to compare it to a number. It can't compare it to the string 'frammis' and so you get the "mismatch" message.
Oh, and the "in criteria expression" usually means it's an error in your WHERE clause.
I can't help you further unless you show the ACTUAL query.