I have an architect, HKS, and I'd like to see, when selecting their name in a splicer or drop down the top 10 other companies of other trades that they work with in a specific range of dates using a project name correlated with a project number to help delineate.
IE
Start Date - 12/1/2016
End Date - 5/31/2018
Specifier - Builder One
Type | Company Name | # of Projects
Engineer | Bobs Engineering | 384
Engineer | Bridge Engineering | 297
Engineer | Abacus | 75
Type | Company Name | # of Projects
Interior Designer | Sal's Curtain Pickers | 384
Interior Designer | Horizon Design | 297
Interior Designer | Johns Furnishings | 75
So on and so forth through General Contractors, Landscape Architects, etc....
The Project Name is in a table “tblOrderandContacts” in Access that shows which project worked with which companies.
The project number is in a table “tblOrdersData” in Access that has Project Name with Project Number.
Both tables show every order associated with each project, multiple orders in some instances and their respective dates.
I need to devise a way to get to the image shown above using these two tables. Any Ideas?
IE
Start Date - 12/1/2016
End Date - 5/31/2018
Specifier - Builder One
Type | Company Name | # of Projects
Engineer | Bobs Engineering | 384
Engineer | Bridge Engineering | 297
Engineer | Abacus | 75
Type | Company Name | # of Projects
Interior Designer | Sal's Curtain Pickers | 384
Interior Designer | Horizon Design | 297
Interior Designer | Johns Furnishings | 75
So on and so forth through General Contractors, Landscape Architects, etc....
The Project Name is in a table “tblOrderandContacts” in Access that shows which project worked with which companies.
The project number is in a table “tblOrdersData” in Access that has Project Name with Project Number.
Both tables show every order associated with each project, multiple orders in some instances and their respective dates.
I need to devise a way to get to the image shown above using these two tables. Any Ideas?