Multiple Records on One Line

[Tony J]

Hi there,

I have the below records that I wish to put in a report...

Region | Store
1 | 123
1 | 234
2 | 345
2 | 456

In the following format

Region 1
123, 234

Region 2
345, 456

Can I do this in a report? Or is there a way to build the report from a
macro to do this?

Appreciate the assistance

Regards

Tony

 

[Duane Hookom]

You should be able to use the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Tony J]

Thats the one

Thanks for your help

You should be able to use the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.