I originally posted a question that Jeffrey Coachman supplied some code that worked great...thanks Jeff.
How can I get multiple records displayed in one line
After running some tests, I am now wanting to do some grouping. For example the returned data is:
W~AP 280 GNC~AP 280 Qu~AS 266 GNC~AUH2 283 ADM~B 465 AGE~BA 278 Qu~BU1 293 ADM~CO 293 ADM~F1 254
I am wanting the AP 280 to be grouped together so it displays like:
W~AP 280 GNC Qu~AS 266 GNC~AUH2 283 ADM etc etc.
This will be the same for any of the same letters after the ~ with the same number.
I hope I have explained this okay....if not please let me know and I shall try to clarify.