[AccessD] how to split text into its letters...

[Rocky Smolin]

I'd probably write that function in VBA, put it in a Public module, and call
it from the query.

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kostas Konstantinidis
Sent: Saturday, July 25, 2015 10:09 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] how to split text into its letters...

hi,
In a field there text values, something like
1234-5679(1678)68:3;1-
What I need is to split text with every character separate by a comma e.g.
1,2,3,4,-,.......,-

Is that possible via query?

thank's
/kostas

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com