Advertisement
- Home
- Software
- Database
- MS Access
- Access Reports
- Build a single report using multiple tables that have one field in ...
Advertisement
- 1. boag2000 471,835
- 2. LSMCons... 170,044
- 3. capricorn1 134,340
- 4. DatabaseMX 132,920
- 5. peter57r 123,521
- 6. harfang 93,096
- 7. jimhorn 76,675
- 8. eghtebas 57,025
- 9. GRayL 56,546
- 10. matthews... 51,534
- 11. irudyk 48,264
- 12. LennyGray 37,352
- 13. omgang 35,882
- 14. JDettman 34,950
- 15. koutny 33,548
- 16. TextReport 31,290
- 17. hnasr 31,082
- 18. OnALearn... 29,643
- 19. frankytee 25,740
- 20. JimFive 19,078
- 21. Rick_Ric... 17,825
- 22. jppinto 17,792
- 23. jefftwilley 17,774
- 24. mbizup 16,335
- 25. puppydog... 15,950
- 1. boag2000 517,679
- 2. capricorn1 234,540
- 3. DatabaseMX 221,590
- 4. LSMCons... 221,462
- 5. peter57r 196,561
- 6. harfang 166,724
- 7. jefftwilley 152,612
- 8. jimhorn 145,247
- 9. matthews... 106,834
- 10. GRayL 91,631
- 11. eghtebas 74,425
- 12. mbizup 72,295
- 13. JDettman 67,430
- 14. frankytee 59,040
- 15. omgang 55,482
- 16. OnALearn... 54,610
- 17. stevbe 51,181
- 18. irudyk 48,264
- 19. LennyGray 42,152
- 20. koutny 39,748
- 21. LPurvis 39,295
- 22. puppydog... 35,405
- 23. ragoran 35,150
- 24. TextReport 34,916
- 25. jjafferr 31,672
| 07.16.2008 at 12:25AM PDT, ID: 23568698 |
|
[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! |
||
Build a single report using multiple tables that have one field in common
Asked by csall in Access Reports, Microsoft Access Database, Access Architecture/Design
Tags: Microsoft, Access, 2003
Report should be sorted by contractor doing the work, then by permit type, then by permit number
Company ABC (Contractor doing work)
- Road Permits (open permits listed and sorted by permit #)
- RD-0120, road A1
- RD-0121, road A2
- Confined Space Permit (open permits listed and sorted by permit #)
- CS-0120, location AB
- CS-0121, location DF
Company AABB (Contractor doing work)
- Road Permits (open permits listed and sorted by permit #)
- RD-0115, road B4
- RD-0130, road C3
- PMC Permit (open permits listed and sorted by permit #)
- PMC-0105, location KS
- PMC-0161, location LL
Company XYZ (contractor doing work)
- Road Permits (open permits listed and sorted by permit #)
- RD-0123, road A4
- RD-0125, road A3
- PMC Permit (open permits listed and sorted by permit #)
- PMC-0118, location DV
- PMC-0119, location ED
The problem I have is this. I have a table that lists the contractors. Then I have multiple tables for each type of permit. The permits types each have unique ID numbers that I use an auto counter to provide the next permit number. If I try to create a query, cannot get it to work correctly. See the attached file.
What I would like to see is the information broken out like above. One contractor, and each line showing a different permit that is open. There should not be info in the Road Permit Number field if there is information in the PMC Permit Number field. (I also noted that all the permit number titles became "Permit Number Issued by PMC" not sure why that happened.)
Any help would be appreciated.
Start Free Trial
