Splitting Data

M

Mark R

I want to do something like Data, Text to Columns in an Access query where I can split the data from one field into separate fields using a space as the delimiter. Because the number in the first field can vary in size, it won't work in Excel and the Left() in Access won't work. Here is the sample data, all in one field

940623 ORL 107100
1007 MIA 129100
10238 WPB 120600

I need it to return the following
Field 1 Field 2 Field
940623 ORL 107100
1007 MIA 129100
10238 WPB 120600

Is there an expression I can use in a query to do this? Thanks
 
Top