Cutting a string in Access

[drimades]

How can I transform a string of the form "firstword secondword thirdword" into 3 strings "firstword", "secondword", "thirdword

 

[PHV]

Have a look at the Split function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[drimades]

sure. thanks!

 

[drimades]

It's ok now. It fills the array, but apriori I don't know how many elements it has?!

 

[missinglinq]

WordCount = Len([YourString]) - Len(Replace([YourString], ",", ""))+ 1

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[PHV]

After the Split function you may use the UBound function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886