'Text to columns' like function

[plannerg]

Hi,

I'm new to Access and was wondering if there is a function that can split/divide the contents of one field into seperate fields like you can do in Excel via the 'text to columns' function. I have people's names (surname christianname in one field in a table and want to have a query that splits them up by the space between the names and put one in one filed and the other in a seperate field).

Hoping someone can help me..

Thanks.

Greg

 

[Brianwarnock]

Search the forum on Split Field