G
Guest
How can I pass multiple values using the IN operator on a numeric field.
Example, the table is "Customer" and I want the user to be able to type in
"N" number of customer numbers to show only those customers. I tried using IN
([enter cust. number]) in the Criteria field but I can only type in one
customer number. If I type 3005, 3006 I get an error. Is this possible, or
am I stuck to one number at a time.
tia
Example, the table is "Customer" and I want the user to be able to type in
"N" number of customer numbers to show only those customers. I tried using IN
([enter cust. number]) in the Criteria field but I can only type in one
customer number. If I type 3005, 3006 I get an error. Is this possible, or
am I stuck to one number at a time.
tia