G
Guest
Good afternoon,
I currently have a query that returns the following format:
Report # dwg # dwg issue
1000576 abc123 A00
1000576 def456 B00
1000576 ghi789 F00
8365888 abc123 B00
However, I need to get the following
Report # dwg # dwg issue
1000576 abc123 A00, def456 B00, ghi789 F00
8365888 abc123 B00
Where I group by Report Number and have a field which enumerate all the dwg
# and issue for each report number?
How can this be achieved?
Thank you,
Daniel
I currently have a query that returns the following format:
Report # dwg # dwg issue
1000576 abc123 A00
1000576 def456 B00
1000576 ghi789 F00
8365888 abc123 B00
However, I need to get the following
Report # dwg # dwg issue
1000576 abc123 A00, def456 B00, ghi789 F00
8365888 abc123 B00
Where I group by Report Number and have a field which enumerate all the dwg
# and issue for each report number?
How can this be achieved?
Thank you,
Daniel