Running Concatenation

[Freddy]

I am trying to create a simple query that will keep a running list of first names, but am having problems. It was done in the design view but here's the sql for discussion purposes:

PARAMETERS RunningList Text ( 255 );
SELECT Family.LastName, ([RunningList] & ", " & [FirstName]) AS RunningList
FROM Family
WHERE ((Family.LastName)="Fleming");

Eventually I'd like to be able to update the RunningList parameter based on some criteria, but can't get the first part to work.

Here's the output:

LastName RunningList
Fleming , Linda
Fleming , Vivian
Fleming , Jacqueline
Fleming , Rosena

I was trying for something like:

Fleming , Linda, Vivian, Jacqueline, Rosena

I've seen code that will do this, but would like to know if it is possible w/o programming first.

 

[Freddy]

Pat, thanks for the reply. Never thought of that one. Another option I was thinking of was some manipulation of results from a cross tab query, but your right, its best coding.