Summary Fields from two tables in same sub-summary

[reichwaldl14]

I have tried to find the answer to this and it appears to be answered in many different places, yet it doesn't work for me. I thought I'd try this:

I have two tables- Table A: Includes items completed (fields include item, date, employee who completed) and Table B: Hours worked by each employee (Fields include, hours, date, employee). Always, employees have multiple records per date in table A. Occasionally, employees have multiple records in Table B per date.

I need to create a summary report that will compute # of items completed per hour worked, break field: Date. Is this possible? How?

[comment]

In the Hours table, can an employee have more than one record for the same date (e.g. 3 hours AM, 5 hours PM)?

[reichwaldl14]

In the Hours table, can an employee have more than one record for the same date (e.g. 3 hours AM, 5 hours PM)?

Yes, occasionally they do.

[comment]

OK, so assuming you have a relationship:

Hours::EmployeeID = Items::EmployeeID

AND

Hours::Date = Items::Date

You can define these fields in the Hours table:

sTotalHours - Summary (Total of Hours)

cItemsPerHour - Calculation =

Count ( Items::ItemID ) / GetSummary ( sTotalHours ; Date )

This should work (I think...), once you sort the records (in the Hours table) by EmployeeID and by Date.

[reichwaldl14]

OK, so assuming you have a relationship:

Hours::EmployeeID = Items::EmployeeID

AND

Hours::Date = Items::Date

You can define these fields in the Hours table:

sTotalHours - Summary (Total of Hours)

cItemsPerHour - Calculation =

Count ( Items::ItemID ) / GetSummary ( sTotalHours ; Date )

This should work (I think...), once you sort the records (in the Hours table) by EmployeeID and by Date.

Woo Hoo! It works. Thank you very much.