Split data by using query

[lamkee]

HI everyone,



I would like to split the data from one field to three or more.
For example,

Field A:
128Pages,1.123M3,Made in USA

I would like use query to split the data as follow,

Field 1 Field2 Field3
128Page 1.123M3 Made in USA


Thanks.

[RuralGuy]

The Split() function used in a User Defined Function (UDF) in a Standard Module would do this very nicely.