Since I'm not an advance user, creating a report according to what my boss required is really a hard task for me...
Well, here my situation:
I have 3 database which is related to this report -
1) Project Database (store project names and project ID)
2) Contract Database (store information about the contracts and related to project database as many-to-1 based on project ID)
3) Sub-Contract Database (store information about the sub-contracts and related to project database as many-to-1 based on project ID)
Important notes: Every Project must have at least one contract but may have zero, one or more than one sub-contracts
I would like to make my report looks like follows:
Project ID
---------------------------------------------------
table with Contract informations of project ID above
---------------------------------------------------
-------------------------------------------------------
table with sub-Contract informations of project ID above
-------------------------------------------------------
Project ID (2)
-----------------------------------------------------
....
I have try to approach this problem by multiple query, or sub-report, but none of them can achieve the format I want.
The main obstacle I have now is that I never do a "breakdown structure" report in access, can anyone help me please
Well, here my situation:
I have 3 database which is related to this report -
1) Project Database (store project names and project ID)
2) Contract Database (store information about the contracts and related to project database as many-to-1 based on project ID)
3) Sub-Contract Database (store information about the sub-contracts and related to project database as many-to-1 based on project ID)
Important notes: Every Project must have at least one contract but may have zero, one or more than one sub-contracts
I would like to make my report looks like follows:
Project ID
---------------------------------------------------
table with Contract informations of project ID above
---------------------------------------------------
-------------------------------------------------------
table with sub-Contract informations of project ID above
-------------------------------------------------------
Project ID (2)
-----------------------------------------------------
....
I have try to approach this problem by multiple query, or sub-report, but none of them can achieve the format I want.
The main obstacle I have now is that I never do a "breakdown structure" report in access, can anyone help me please