Search results
-
K
text criteria in table gives data type mismatch
Ok JanR, I am looking at your answer again, and I think I see how that can work...I have other search fields with similar challenges using different operators, but essentially I need to keep the operator out of that text field that needs to be coerced to a currency type. Thanks very much! -
K
text criteria in table gives data type mismatch
ListPr is a text field that contains an expression, not just a number. I want it to contain for example "<200000", or for another example "Between 100000 And 200000". All of these expressions work in the sql by putting them in directly, but getting the expression to pass from the table where... -
K
text criteria in table gives data type mismatch
Thanks Rain, but the idea here is to have query criteria in a table to set up and manage hundreds of different searches. -
K
text criteria in table gives data type mismatch
Thanks JanR, and I have tried both. Then tried many combinations of those with quotes here and there. If I had one price in the ListPr field, then then CCur() works great. But it's the text string that I need for the criteria to evaluate the currency field in the other table. So this works... -
K
text criteria in table gives data type mismatch
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.*...