[AccessD] values separated by .

Pedro Janssen pedro at plex.nl
Fri Feb 18 07:00:02 CST 2005


Hello group,

I have a field [formula] with values that look like:  6.11.3.1.2(0m).1.0.1
Each value is separated by a dot  (.) 
As you can see, not al values are numbers.

I would like each value in a separated field. FieldA to FieldH.

I could do this with Left, Right or Middle function, but it takes time an 8 functions

Is there a better way to do this in one.

Pedro Janssen



More information about the AccessD mailing list