fair Warning - Admittedly I'm far from an access expert, but I'm not a
beginner either.
I want to split a value into multiple parts as delimited by a character
- all as part of a query. For example, one specific column in a table
contains values like "eggs/ham/potato" and "toast/fruit" and as I run a
select query against this table, I want to split the above values into
"eggs", "ham", "potato" (3 values)and "toast","fruit" (2 values)
My research has led me to the VBA function Split() but I've been
unsuccessful in incorporating the function into a query.
Thank you for your time.
*** Sent via Developersdex http://www.developersdex.com ***