Skip to main content
Inspiring
March 20, 2007
Question

Saving comma delimited results as separate fileds.

  • March 20, 2007
  • 1 reply
  • 316 views
Does anyone know the easiest way to separate a comma delimited query result into different fields?

Something like:

item,item,item,item,item

into form fields...

item1 item2 item3 item4 item5

Something simple I'm missing.

Thanks!
David
This topic has been closed for replies.

1 reply

March 20, 2007
Define a query record with the columns as you expect your no of items.
Insert the values as a record, you now can access <queryname>.<columnname>