How do I combine records and fields

[Tom Weston]

Hello
I have a query that obtains it's data from 3 tables. The output looks like:
club name, persons name, team type, team number

so with data:
GPBC, Tom, mixed, 1
GPBC, Tom, mens, 2

there is a record for each person and each team they play for. So there can
be several records for 1 person if they play in more than 1 team.
I would like to create report with a line for each person which includes all
the teams that they play for, like:
club name, persons name, team type, team number, team type, team number etc

so with data:
GPBC, Tom, mixed, 1, mens, 2

Hope that makes sense, I have tried to do this but failed, can you help
please.

Tom

[Bernard Peek]

In message <ch**********@blackmamba.itd.rl.ac.uk>, Tom Weston
<t.********@dl.ac.uk> writes

there is a record for each person and each team they play for. So there can
be several records for 1 person if they play in more than 1 team.
I would like to create report with a line for each person which includes all
the teams that they play for, like:
club name, persons name, team type, team number, team type, team number etc

so with data:
GPBC, Tom, mixed, 1, mens, 2

Hope that makes sense, I have tried to do this but failed, can you help
please.

Can you clarify what tables you have and the relationships between them?


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Bernard Peek]

In message <ch**********@blackmamba.itd.rl.ac.uk>, Tom Weston
<t.********@dl.ac.uk> writes

Hello
I have a query that obtains it's data from 3 tables. The output looks like:
club name, persons name, team type, team number

so with data:
GPBC, Tom, mixed, 1
GPBC, Tom, mens, 2

there is a record for each person and each team they play for. So there can
be several records for 1 person if they play in more than 1 team.
I would like to create report with a line for each person which includes all
the teams that they play for, like:
club name, persons name, team type, team number, team type, team number etc

so with data:
GPBC, Tom, mixed, 1, mens, 2

Hope that makes sense, I have tried to do this but failed, can you help
please.

I got a copy of the document you sent me by email. Generally I prefer to
see stuff posted to the newsgroup so that everyone can see it.

Have you investigated the crosstab query wizard. If so, what problems
did you have with it?

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Pieter Linden]

use fConcatChild from here....
http://www.mvps.org/access/modules/mdl0004.htm

[Tom Weston]

Bernard
The cross tab query does just what I want. Thanks for all your help.
Tom

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:Zp**************@shrdlu.com...

In message <ch**********@blackmamba.itd.rl.ac.uk>, Tom Weston
<t.********@dl.ac.uk> writes

Hello
I have a query that obtains it's data from 3 tables. The output looks like:club name, persons name, team type, team number

so with data:
GPBC, Tom, mixed, 1
GPBC, Tom, mens, 2

there is a record for each person and each team they play for. So there canbe several records for 1 person if they play in more than 1 team.
I would like to create report with a line for each person which includes allthe teams that they play for, like:
club name, persons name, team type, team number, team type, team number etc
so with data:
GPBC, Tom, mixed, 1, mens, 2

Hope that makes sense, I have tried to do this but failed, can you help
please.

I got a copy of the document you sent me by email. Generally I prefer to
see stuff posted to the newsgroup so that everyone can see it.

Have you investigated the crosstab query wizard. If so, what problems
did you have with it?

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.