Report List with Commas

[S]

Hello,
In my database, I have a table with Company Name, First name, Last name.
Example Data..

Shawn's Store Shawn Doe
Shawn's Store Jane Doe
Shawn's Store Peter Paul
Microsofts Store Harry Clein
Microsofts Store Count Johns
Microsofts Store Mary Smith

I would like to create a report that would group on Company name, and then
list the First name then Last name followed by a comma and continue listing
the names horizontally like so..

Shawn's Store
Shawn Doe, Jane Doe, Peter Paul

Microsofts Store
Harry Clein, Count Johns, Mary Smith


is this possible. everything i try gives me a list vertically and isn't what
i want. Any help would be greatly appreciated.

 

[GBA]

going horizontal is not database centric...which is why you are having a hard
time finding a technique.

you could probably try a crosstab query - - and then use that as a record
source for a report....I haven't ever tried this though....

 

[John Spencer MVP]

See Duane Hookom's sample at

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[S]

The example is what i need however I'm having trouble converting the code for
my database.

 

[John Spencer]

Did you read the comments in the code about commenting out some lines
and commenting in some other lines?

Comment out - add an ' at the beginning of the line
Uncomment a line - remove the ' at the beginning of the line

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[S]

I got the code to work!

The only thing I'm wondering now...i scan the list be put into alphabetical
order by last name?

 

[S]

silly question... just put order by in code.

all set. thanks everyone!