Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Using Mutliple Fields

Status
Not open for further replies.

andyhall

Technical User
Nov 20, 2002
5
US
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
.
.
 
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.
 
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!
 
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......
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top