What would be the calculation to display only the first letter in each word?

?? Left ( order_quantities::orders_name; 1 ) ??

Thanks

When dealing with having to perform a function on an unknown number of entities, in this case, Left() on an unknown number of words, a recursive custom function is usually needed.

When dealing with having to perform a function on an unknown number of entities, in this case, Left() on an unknown number of words, a recursive custom function is usually needed.

Thanks DJ

What would a custom function like this look like?

When dealing with having to perform a function on an unknown number of entities, in this case, Left() on an unknown number of words, a recursive custom function is usually needed.

Usually, yes - but not in this case:

http://www.fmforums.com/forum/showpost.php?post/288567/

You know what's funny (well to me)...I actually cut this line from my original response:

"But I'm sure comment will have a clever way of accomplishing this with a simple calculation."

That's verbatim from a sticky I use to compose my forum posts.

I didn't want to seem pandering. :(

Well, this one is Daniele's, not mine. I'm surprised you didn't remember it, since you helped to simplify it in the original thread:

http://www.fmforums.com/forum/showtopic.php?tid/192288/

I didn't want to seem pandering.

Pandering to what?

Maybe I'm not using the word right, doesn't it have the sense of "providing excess flattery?"

Ahm, no. BTW, you're welcome to provide excess flattery at any time. Actually, I don't mind if you pander to my wicked desires either - I'd just like to be clear on which one is it. :(

OK I'm getting a mental picture of you guys sitting around in black and white furry bear suits chewing on bamboo... am I warm?