Hello-
I am attempting to use the VALUE worksheet function in a Query. The field in the table that I am querying is a text field that usually contains numbers, but can also contain text. That is why I have it set to text. Anyways I want to do a Between search on the field, ie : Between 99999999 and 999999999999. I tried to use the Value worksheet function to do this but I keep getting a data mismatch error. In my query I created an expression as follows;
VariableField: Value([Field])
Does anyone have any suggestions as to how to accomplish this using the Value function? Or perhaps does anyone have any other ideas?
Thanks,
David
I am attempting to use the VALUE worksheet function in a Query. The field in the table that I am querying is a text field that usually contains numbers, but can also contain text. That is why I have it set to text. Anyways I want to do a Between search on the field, ie : Between 99999999 and 999999999999. I tried to use the Value worksheet function to do this but I keep getting a data mismatch error. In my query I created an expression as follows;
VariableField: Value([Field])
Does anyone have any suggestions as to how to accomplish this using the Value function? Or perhaps does anyone have any other ideas?
Thanks,
David