B
baron2005
I have a data access page which relies on a view created in SQL Server.
Several of the incoming fields contain multiple values. The values are
identified in their respective fields via comma-separated delimiters.
I would like to split the comma-separated values into distinct items within
a drop down list.
I have used text to columns in excel, but that only splits the values across
columns. I want to place all values into a selection list, is this possible
from the Access Data Page?
Several of the incoming fields contain multiple values. The values are
identified in their respective fields via comma-separated delimiters.
I would like to split the comma-separated values into distinct items within
a drop down list.
I have used text to columns in excel, but that only splits the values across
columns. I want to place all values into a selection list, is this possible
from the Access Data Page?