Print Report w/ multiple 1-to-manys

[Guest]

I have an alumni database. I want to print out a report listing their names,
former offices, and telephone numbers. I have a 1-to-many relationship to
offices and telephone numbers so I seem to only be able to make a report
showing either offices or telephone numbers. otherwise the report contains
only the first office or first telephone number. Is there a way around this?

 

[Douglas J Steele]

It would help if you indicated what your tables are, and how they're
related.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have an alumni database. I want to print out a report listing their names,
former offices, and telephone numbers. I have a 1-to-many relationship to
offices and telephone numbers so I seem to only be able to make a report
showing either offices or telephone numbers. otherwise the report contains
only the first office or first telephone number. Is there a way around

this?

 

[Guest]

Main table on alumni relates to look-up table matching alumni ID to Office
ID. The second relationship is identical (let's look at departments, rather
than telephone numbers).

I want
James Spader --- Madrid, London-----M&A, Tax
to appear in the the report, but each former office and former department
is related through the lookup table. I can get one to show up in a report,
but not both. For an input form, this was resolved by creating separate tabs
for each of these fields.


"Douglas J Steele" escribió:

 

[Douglas J Steele]

To get it in the format you display below (one row per alumnus, with all of
the offices and all of the departments on that one line), you could create a
query that uses either of the concatenation functions from
http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" twice:
once for each of the tables. I'd expect that the query will be quite slow,
though.

 

[Guest]

Ah, that makes sense. Thanks.

To get it in the format you display below (one row per alumnus, with all of
the offices and all of the departments on that one line), you could create a
query that uses either of the concatenation functions from
http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" twice:
once for each of the tables. I'd expect that the query will be quite slow,
though.