query question

N

nycdon

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
 
J

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
Click to expand...

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]
 
Top