List and Reports

J

Jaime

I have a record that has a list of items attached to it.
When I do a report I want the items of the list to display
horizontally for each record.
Rather than vertically.

Can this be done?

Thanks
 
M

Marshall Barton

Jaime said:
I have a record that has a list of items attached to it.
When I do a report I want the items of the list to display
horizontally for each record.
Rather than vertically.

Depends on what you mean by "list of items". If it's a
bunch of values in another table in a one to many
relationship with your main records, then you'll have to use
a function to construct the string of items. There's
several out there on the web that you could search for
(Google). Here's one to get you started:
http://www.mvps.org/access/modules/mdl0004.htm
 

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