How to create a report as a breakdown structure form?????

stephenwu

New member
Local time
Today, 15:37
Joined
Jun 2, 2006
Messages
6
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 :confused:
 

Users who are viewing this thread

Back
Top Bottom