I am hoping the right number and placement of quotation marks will make this work. I have this in a text field >100000. I want to use that text field as criteria in a query to look up a currency field. I get a "Type mismatch in expression" dialogue. Here's the sql:
SELECT A5.*...
