Problem with Sub report format

[Epoh Rio]

Hi all, I have a subreport that displays items purchased by filling down. The
problem is it is taking up too much space. How can I fill right by separating
each item by comma?

This is how the report looks now:

Customer:
Jon Doe 123 N Main Anywhere, USA
Items purchased:
Wrigley's gum
Icebreaker mints
Hostess donuts
Twinkies

===============================================
This is how I want the report to look:

Customer:
Jon Doe 123 N Main Anywhere, USA
Items purchased:
Wrigley's gum, Icebreaker mints, Hostess donuts, Twinkies

Is this possible?

Thanks,

 

[Allen Browne]

Create a function that returns a concatenated string of the items.

Details in:
Concatenate values from related records
at
http://allenbrowne.com/func-concat.html

 

[Epoh Rio]

I tried this and I failed to mention one thing:

ItemsPurchased is found in a separate table I am linking the Child & Master
Fields by ID.

So when I use your statement:
=ConcatRelated("ItemsPurchased", "ID" )

Access wants a value for "Items purchased" because it is in a sub_rpt

I tried it in the sub_rpt but it didn't work too well.

It keeps giving my Error 3078:

The MS Jet database engine cannot find the input table or query
'ItemsPurchased'....

 

[Epoh Rio]

Sorry I misunderstood your article.

I missed the part that the second item was the tableName.

My fault.

After correcting that, I changed it to:
=ConcatRelated( "ItemsPurchased", "tblPurchaseHistory")

I am now prompted to enter parameter value of ConcatRelated when I run the
report.

 

[Cadstillo]

My mistake yet again...

 

[Allen Browne]

You must pass 3 things to the function. The 3rd one is the criteria
identifying which records to return.

Get an example working with some literal values in the Immediate Window
(Ctrl+G.) Once you have it all working, you can transfer that approach to
the report.