Displaying Data in a Report

[im_eric]

I am designing a database to track magazines... Okay, you got me, comic books. I want to design a form that lists the titles and the issue numbers in a single row. That way, I can print the report and take it with me. I won't have repeat buys or miss any.

So my question is how do I get the dsta to display horizontally? Ordinarily, my report would display the data like this:



Spider-Man 1
Spider-Man 2
Spider-Man 3
Superman 1
Superman 2
Superman 3

I want the report to display the data like this:

Spider-Man 1, 2, 3
Superman 1, 2, 3

I'm just not sure how to get the IssueNum field to do that. Also, can I assume that I have to place the IssueNum field in a sub-form from the Title field so I get only get one Title in the report?

THANKS! I appreciate any help I can get.

--Eric

[pbaldy]

This type of thing?

Return a concatenated list of sub-record values

[im_eric]

I'm thinking that's probably going to work. THANKS!

[pbaldy]

Happy to help, and welcome to the site! I've got more if they seem better:

ACC2000: How to Concatenate Data from the 'Many' Side of a Relationship

http://allenbrowne.com/func-concat.html