By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,337 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

How do I combine records and fields

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
use fConcatChild from here....
http://www.mvps.org/access/modules/mdl0004.htm
Nov 13 '05 #4

P: n/a
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.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.