T
Tom TBD
Please Help!
I am trying to split a field in a table into a number of
fields in a query. The only problem is, the fields are of
various lengths with various numbers of words/characters.
I want to split the field at each space. e.g
Vauxhall Corsa Club 1.4 Black
Vauxhall Astra
The above is an example of the data I am working with, and
need to split the informaion into separate fields (a bit
like text to columns in Excel). I have tried using the
Left, Mid and InStr functions with a little success,
though I still cant split the field entirely. Any help
would be very much appreciated!!
Regards
Tom
I am trying to split a field in a table into a number of
fields in a query. The only problem is, the fields are of
various lengths with various numbers of words/characters.
I want to split the field at each space. e.g
Vauxhall Corsa Club 1.4 Black
Vauxhall Astra
The above is an example of the data I am working with, and
need to split the informaion into separate fields (a bit
like text to columns in Excel). I have tried using the
Left, Mid and InStr functions with a little success,
though I still cant split the field entirely. Any help
would be very much appreciated!!
Regards
Tom