changing detail on report to sit horizontally

[sandy2011]

Hi folks,

Any ideas please?

Products report
shows on report as:

Order no Product
Order no Product
Order no Product

eg.
012345 table
012345 chairs
012345 lamp

I want to show
Order no Product, Product, Product

eg.
012345 table, chairs, lamp

Any idea?

 

[vbaInet]

Have a look here:

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

 

[sandy2011]

For the example above, you could set the ControlSource of a text box to:
=ConcatRelated("product","scheme_opdetm","order_no = " & [order_no])

Unfortunately it didn't work in report.. when I run the report.. it is asking for a parameter value ConcatRelated

 

[vbaInet]

The code needs to go in a Module, not a Class Module or the module of the report but a new Module of its own.

 

[sandy2011]

The code needs to go in a Module, not a Class Module or the module of the report but a new Module of its own.

Many thanks but I am lost.. I have never setup modules..

 

[vbaInet]

Do you know to get to the section where VBA code is written? What version of Access are you using?