Linking between daily information and a monthly table?

[sewilj]

I would be greatful for any help on the following...

I have to create a report which displays results of daily activity by employees, but also incorporates a calcluation based on the total number of hours worked in the month. Currently I have my report grouped by month and then by week. I have 2 tables, CPCASE (which includes information against a single daily action, of which there are several hundred per day) linked by the DateTime field, against the monthly (DateTime) field in the table DEPLOYED. The DEPLOYED table contains 2 fields, the first containing the start date of each month, the second holding the total number of hours worked each moth.

I would like to display this monthly total against the monthly summary information from the daily activities. What I keep finding is that because the 2 tables are linked using an equals SQL join type, whenever I include a fieled that contains the mothly hours field it limits the daily activity data to only those that occur on the first of each month.

I hope this makes sense and any help would be great