Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to select multiple records in a table by using an input box. I am able to select a single record, but not multiple.
I am taking my records from an excel spreadsheet and cutting and pasting into the input box. I have tried both a | as well as a , as delimiters.
I am using a button to Select in Field.
What am I doing wrong?
Delimiter | is correct, and don't forget the parenthesis:
(value1|value2|value3)
Delimiter | is correct, and don't forget the parenthesis:
(value1|value2|value3)
and, if I'm not wrong, with space
("value 1"|"value 2"|"value 3")
You're certainly not wrong. It is safe to use "" every time if there is a possibility of a space.
Thanks everyone. I was able to get it to work. I added a | in the excel data. I then cut and pasted the data into the input box. On the button I added '('& variable &')' to the Select in Field value
thanks again!