report output

[Guest]

I have a report with a subreport. Basically what is happening is that I have
material transfer reports that have inventory in them (according to what has
been bought, sent, shipped, etc). Each report corresponds to each material
transfer. I have the subreport corresponding to an inventory code for each
item showing up in the report. The problem is that each inventory item might
have multiple codes. Is there a way of having the codes fill in like the
following:

Item: Codes:
Item A 1
Item B 2, 7, 13
Item C 2, 4

rather than

Item: Codes:
Item A 1
Item B 2
7
13
Item C 2
4

The codes are coming from a query that has the item characteristics in it
that determines what code it gets. Thanks for the help, hope you understand

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0004.htm and/or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web"