query question

[Guest]

for sample below from 1 table, how could I get all the projects for each
client..i assume a self-join maybe?

client project
----- -------
abc web develop
abc db work
abc consult
cbs consult

 

[John Vinson]

for sample below from 1 table, how could I get all the projects for each
client..i assume a self-join maybe?

client project
----- -------
abc web develop
abc db work
abc consult
cbs consult

Do you mean get them all on one line, as in

abc web develop, db work, consult
cbs consult

I presume?

If so, check out the code at:

http://www.mvps.org/access/modules/mdl0004.htm


John W. Vinson[MVP]