problem of print two piece of information (returned by a procedure) on seperate columns..

[Rex]

Hi,

I have written a procedure that returns a string value.. this value
contains two pieces of information.. A date and a number seperated by a
whitespace.. when I run this procedure through a query I get the both
these pieces of information on the same column. My question is: Is
there any way of getting this information on two seperate column.

I know this task would have been achieved if a procedure could return
more than one values.

Cheers
Rex

 

[Allen Browne]

You can use Split() to parse the words, but it needs a function wrapped
around it to work in the context of a ControlSource.

Copy the ParseWord() function from:
http://allenbrowne.com/func-10.html
and paste it into a Module in your database.

You can then set the the Control Source of your text box to:
=ParseWord(YourFunction(), 1)
for the first word, and 2 for the 2nd one.