Hello,
I am trying to run a query that pull all the records base on an entry a user make on a form. for example. Consider selecting all records where multi OrderNo entered by the user on a form seperating them by ; .
I am using the select statement below but getting no result. if I enter one order then I get result. Please advice.
Select * from Orders WHERE OrderNo In ([Forms]![myform]![UserEntry])
Note: where User's Entry could look like 1235;2345;3456
thank you in advance.
I am trying to run a query that pull all the records base on an entry a user make on a form. for example. Consider selecting all records where multi OrderNo entered by the user on a form seperating them by ; .
I am using the select statement below but getting no result. if I enter one order then I get result. Please advice.
Select * from Orders WHERE OrderNo In ([Forms]![myform]![UserEntry])
Note: where User's Entry could look like 1235;2345;3456
thank you in advance.