Help with a query or a report

S

Serg Matvienko

Hi everybody,



In short, there are 3 tables - A, B, C for example. The table A has 2
fields - PersonCode, PersonName. The table B has PersoneCode, LanguageCode
and the table C - LunguageCode, LanguageName. The table A is a master table,
the table B is a detail table because every person can speak several
languages. I need a report or a query where every person has only 1 row,
and this row contains only 2 columns - a name of person and a list of
language names separated with commas. Please help to make the query .



Thank in advance,



Serg
 
D

Duane Hookom

At least one reply to this same question posted in another NG. Please limit
your questions to a single NG.
 
S

Serg

Hi Duane,

Thank you a lot for the nice link you sent me. You helped me very much. I'm
sorry, but I posted my question in two NG only because i was not sure that
it is possible to crack this problem using only SQL query.

Sincerely,
Serg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a query or a report 5
SQL query for Access.MDB file doesn't work,F1 1
Joining 3 Queries That Count 8
AND query 4
Need a query to get rid of duplicates using two tables 1
Query that will look for duplicate in two tables. 3
Selecting Distinct Records in union query/report 5
Query to display highest totals 1

Top