Need help

[Suresh_Murugan]

I have a limited records, but all multiple group & more than 15 records in one group. I was created report group header and detail showing records one by one. I want one group header and detail showing one list box or text box all related records with comma. Please help

 

[Gasman]

I have a limited records, but all multiple group & more than 15 records in one group. I was created report group header and detail showing records one by one. I want one group header and detail showing one list box or text box all related records with comma. Please help

I used this

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

 

[Suresh_Murugan]

see the details of my table
Po No SS No
PO001 94-2-06
PO001 94-2-04
PO002 94-2-05


This is showing in group Header PO001
94-2-06
94-2-04

But I want group Header PO001

94-2-06,94-2-04

 

[Gasman]

So use the function with space as delimiter?

This is the result of my using it with a comma as delimiter.

http://www.bibby-gazette.co.uk/leave.html

Each dept is a group header like your PO001

 

[Suresh_Murugan]

I attached my database

 

[Suresh_Murugan]

I was try in your way. But I get a Error:3075 message

 

[Gasman]

I was try in your way. But I get a Error:3075 message

I've started you off with what you have supplied.
The rest is up to you.

Pay attention to the format when the key field is text and not numeric.