Displaying Multiple Items

J

JZ

On a form the user choses multiple topics that are
associated with their program (Relationship: One Class
can have Many Topics). Near the class title(on a roster)I
want to display each topic that was selected. Currently
you have to read the topics from top to bottom because I
have my "Topic" field in the detail section under the
class heading. Is there a way to have these topics display
from left to right one right after another if more than on
topic was selected?

Ex: TopicA, TopicB, TopicC,
 
B

Bruce

Not sure I understand, but perhaps your topics could be in
a subreport. If so, in the subreport's page setup, set
the columns to go across, then down. Another possibility
might be a concatenated value in a text box or query. It
depends on how you have set up your database. If you need
more than this, you will need to supply some more details
about the database.
 
M

Marshall Barton

JZ said:
On a form the user choses multiple topics that are
associated with their program (Relationship: One Class
can have Many Topics). Near the class title(on a roster)I
want to display each topic that was selected. Currently
you have to read the topics from top to bottom because I
have my "Topic" field in the detail section under the
class heading. Is there a way to have these topics display
from left to right one right after another if more than on
topic was selected?

Ex: TopicA, TopicB, TopicC,


Duane has a function to help do this:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top