Can a query do ...

[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

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

Duane,

Thank you! That was exactly what I needed.

Daniel