Summarize data between three tables

[Scott Pon]

I'm trying to summarize the amount of training hours for a specific department.  I have 3 tables. 

Table1: List of people.  Fields: Personnel Key, Person name, department Number

Table2: List of Training.  Fields: Date of training, number of hours, Personnel Key (from the Date, I get the Year and Month)  

Table3: List of Year/Month.  This is where my calculations should display.  I have a field for Month and Field for Year. 

Relationship #1: Table1::Personnel_Key = Table2::Personnel_Key

Relationship #2: Table3::Year = Table2:Year, and Table3::Month = Table2::Month

In Table3, I want to get a total of Table2::Number of Hours for Department 1.  I created a field that will "Sum (Table2:Number of Hours)" but that will return ALL hours. How do I filter the hours in Table2 on Table1::Department Number = 1?

Thanks.

[Steve Martino]

I don't think you need the 3rd table. Seems like you could use summary fields, sub summary reports and finds in the second table to summarize your data. 

Can you post a sample file?

[Scott Pon]

I did it this way and it works.  Thanks for your help.