Multiple Table Report

[terischmig]

Using MS Access.
I have three tables: 1) tbl_Deliverables 2) tbl_KeyDates 3) tbl_Projects. tbl_Deliverables and tbl_KeyDates are both linked to tbl_Projecs by ProjectID. How may I run a report with the data from tble_Deliverables & tbl_KeyDates? I've tried creating a query first, but I cannot figure out the logic of this. It seems like a simple task.

Thank You in advance for taking the time to read/reply

 

[dhookom]

How are Deliverables related to KeyDates? If they are only related many to one to Projects then you will probably need to put one or both in a subreport.

Duane
Hook'D on Access
MS Access MVP

 

[terischmig]

Thank you.
Deliverables are only created to KeyDates via the ProjectID.
I did try a subrpt_KeyDates, but how do I get it to not print for every Deliverable? I have about 10-15 Deliverables and 3-5 KeyDates per 100+ Projects.

 

[dhookom]

If I understand correctly the Deliverables and KeyDates aren't related to each other. If this is the case then the KeyDates subreport should be added to the Project group header or group footer section.

Duane
Hook'D on Access
MS Access MVP

 

[terischmig]

Thank you very much - I got it!