- Home
- Microsoft
- MS Development
- MS Access
- Help!!! Query/Subreport
Advertisement
| Hall of Fame |
- 1. capricorn1497,479
- 2. DatabaseMX300,318
- 3. LSMCons...223,216
- 4. matthews...148,908
- 5. peter57r109,397
- 6. GrahamM...107,016
- 7. GRayL82,500
- 8. JDettman81,559
- 9. puppydog...74,770
- 10. Helen_Fe...69,064
- 11. thenelson54,468
- 12. cactus_d...54,452
- 13. JezWalters47,416
- 14. SimonAdept46,307
- 15. fyed44,584
- 16. Torrwin44,370
- 17. hnasr37,910
- 18. kelvinsparks36,252
- 19. HainKurt35,786
- 20. Bitsqueezer30,537
- 21. OxonDev29,343
- 22. harfang26,090
- 23. ErezMor24,650
- 24. Tramtrak23,890
- 25. tbsgadi22,021
- 1. capricorn113,703,472
- 2. DatabaseMX6,592,429
- 3. rockiroads6,053,947
- 4. nico50385,705,281
- 5. LSMCons...5,649,097
- 6. peter57r5,256,004
- 7. LPurvis3,655,359
- 8. GRayL3,393,362
- 9. harfang3,386,745
- 10. shanesue...3,288,317
- 11. stevbe2,861,511
- 12. boag20002,812,505
- 13. jimhorn2,808,217
- 14. matthews...2,700,182
- 15. mbizup2,388,890
- 16. thenelson2,344,970
- 17. flavo2,117,383
- 18. jadedata1,968,277
- 19. puppydog...1,962,886
- 20. jefftwilley1,898,620
- 21. cactus_d...1,756,744
- 22. JDettman1,587,651
- 23. eghtebas1,548,179
- 24. jjafferr1,344,995
- 25. dannywar...1,330,887
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Help!!! Query/Subreport
Asked by Kdankwah in Microsoft Access Database
I have a database with several related tables:
Contacts table with one record per contact
Relationships table with several records per contact – one record for each relationship a contact has to an organization (multiple contacts, multiple organizations)
Organizations table with one record per organization
The three tables are joined on id numbers. The contacts table is joined to the relationships table; the relationships table is joined to the organizations table.
I am trying to build a report and a data entry form that will have, grouped by organization, a list of the contacts related to it (from the contacts table), and the details of their relationships (from the relationships table). I have been trying to use subreports and subforms to do this, but while I can do one tier of subreports (i.e. main report based on organizations table, subreport based on contacts table), I am unable to reach through to a second table to include data from the relationships table as well.
I thought I might be able to do this by basing the report/form on a query, but when I put fields from more than one table in a query, the query either returns no data, or only records for which there is data in all the involved tables. (Not all records in one table will always have related records in all the others).
Any ideas would be most appreciated.
Kofi
| [+][-]02/05/04 07:49 AM, ID: 10281374Accepted Solution |
Your question has an Asker Certified™ answer! Kdankwah verified that this solution worked for them--which means it will likely work for you, too. Click to view the solution free for 30-days now.
