Combined Text Summary Field (Order and Clean)
The Combine Text summary field is great. But what I would like to do is determine the order -- Which I have achieved by creating a [Order] field within my child table.... [Combine Text Field] = 1 G...
Forum Discussion
Mark,
Your formula works great for removing the ";" --- any suggestions for removing the numbers --
1 Group A, ; 2 GroupD, ; 3 GroupH, ; 4 GroupY, ; 5 GroupU, ; 6 GroupK
I use the numbers to allow me to determine the order ---
Thank you
Your formula works great for removing the ";" --- any suggestions for removing the numbers --
1 Group A, ; 2 GroupD, ; 3 GroupH, ; 4 GroupY, ; 5 GroupU, ; 6 GroupK
I use the numbers to allow me to determine the order ---
Thank you
Is that that applying right(variable, 6) function mentioned above give you the desired outcome to remove the initial digits.
------------------------------
Babi Panjikar
------------------------------
------------------------------
Babi Panjikar
------------------------------