Child/Master Link in Report with SubReport

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

Stacey Crowhurst

Hi. I have a report that shows contracts by vendor. There is a subreport on
this report that shows the change order history and details. For the main
report each contract is separated by project ID. Currently, the subreport is
connected by contract ID. Can I also connect it by project ID?

Here is what I see now:
ABC Seating PO#2322
Project ID Contract Amount Change Orders Paid to Date
Remaining
#1 $50 $(25)
$25 $0
Project ID Contract Amount Change Orders Paid to Date
Remaining
#2 $1,000 $250
$750 $500

Change Order History
CO#1 11/01/09 $(25) Order came in under quoted amount.
CO#2 11/15/09 $250 Additional chairs for Auditorium



Here is what I would like to see:
ABC Seating PO#2322
Project ID Contract Amount Change Orders Paid to Date
Remaining
#1 $50 $(25)
$25 $0
Change Order History
CO#1 11/01/09 $(25) Order came in under quoted amount.

Project ID Contract Amount Change Orders Paid to Date
Remaining
#2 $1,000 $250
$750 $500
Change Order History
CO#2 11/15/09 $250 Additional chairs for Auditorium.

Any suggestions? Please let me know if you need more information or
clarification.

THANKS!!!
Stacey
 
Certainly, If you have multiple projects per contract, then it would be
appropriate to link subreports by Contract and Project, although I would
probably have a Grouping by the ContractID, so that you can put the general
contract information at the beginning of the report, then have the ProjectID
in the detail section, followed by the subform, linked by ContractID and
ProjectID.

HTH
Dale
 
Thanks Dale. How do I tell Access to link on both the ContractID and
ProjectID for the subform?
 
Back
Top