query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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