Data Layout Problem

[Guest]

I have a question that hopefully has a simple answer, however I am completely
stumped. I have a query that returns data from a table like so.

Account_Code Invoice_Number
1 AB12345
1 AB12346
1 AB12347
1 AB12348
2 AB12349
2 AB12340

In the report I would like to show that data like this

Account_Code Invoice_Records
1 AB12345, AB12346, AB12347, AB12348
2 AB12349, AB12340

There is other information that will be in the report, but I can't figure
out how to get that data presented this way. Any help would be great as I
have hit a roadblock on this.

Thanks,
Jim Stephens

 

[Allen Browne]

You will need to programmatically combine the related values into a string
if you want them to appear beside each other like that.

See the code in:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm