Report Using Mutliple Fields

[andyhall]

I currently have a database with multiple tables linked by the field "Contact ID." For the sake of discussion, let's assume the tables are as follows: "Contacts" with information such as name, address, phone #, etc.; "Languages" with the languages spoken by each contact; "Countries" with the countries in which each contact has worked; and "Organizations" with the organizations with which each contact has worked. Users currently query the database by putting the desired values in a form. The results are displayed in a form as well. The Contacts, Languages, and Countries are displayed in subforms linked to the main form by Contact ID. My problem is that I can't figure out how to create a report like the one below. Ideally, users would still query the database using the form but would then see their results in the report as opposed to a form. I would greatly appreciate any help.

EXAMPLE OF DESIRED REPORT LAYOUT

ID NAME LANGUAGES COUNTRIES ORGS
1 John Doe French Canada UN
German Paraguay USAID
Italian Sweden
Uraguay
4 Jane Doe Chinese Afghanistan CDC
Japanese England IMF
Romanian Ethiopia UN
Russian
7
.
.

 

[CosmoKramer]

Andy,

You should be able to set up a "main report" / subreports relationship just like you now have a "main form" / subforms one. The linking field for each subreport would be Contact ID, linked to the Contacts table.

 

[andyhall]

Cosmo,

The report seems to be working perfectly. Thanks a bunch!! Do you think I should be able to launch the report (really launching a query) from the input form without being prompted to input the parameters? This is not a requirement but would certainly make the application flow more smoothly. Again, thanks for your help!

 

[CosmoKramer]

Sure, look up the OpenReport method in Access help. Your wherecondition could be where the ContactID in your report is equal to the ContactID on your form......