ajaeclarke
asked on
Help with previous question...getting table data into one line...group by
Hi
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.
Thanks
Ajae
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.
Thanks
Ajae
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
post a new question for another problem
ASKER
I have another questions about a field that I want displayed in a certain way...should I accept these solutions and start another question?