Can not allocate(distribute) data equally(evenly)

[J.Brunt]

First off, apologies - new to access...but have been
staring at this for a few days now.

I am working on a staffing requirements db.
It runs for a quarter of the year.
Each employee has given ReportingHrs and OtherHrs for each
client.
ReportingHrs are calculated by title and fall into a
WorkingDate:

IIf(qryFundEntries.StaffTitles=1,DateAdd('d',-
2,tblFund.FinancilStatDue),
IIf(qryFundEntries.StaffTitles=2,DateAdd('d',-
4,tblFund.FinancilStatDue),
IIf(qryFundEntries.StaffTitles=3,DateAdd('d',-
7,tblFund.FinancilStatDue),
IIf(qryFundEntries.StaffTitles=4,DateAdd('d',-
7,tblFund.FinancilStatDue),
IIf(qryFundEntries.StaffTitles=5,DateAdd('d',-
10,tblFund.FinancilStatDue)))))) AS WorkingDate

In order to see when folks are busy, I have grouped the
report by week of quarter:

DatePart("q",WorkingDate) AS QuarterofYear,
DatePart("ww",WorkingDate) AS WeekOfYear,
IIf(QuarterofYear=2,WeekOfYear-13,IIf
(QuarterofYear=3,WeekOfYear-26,
IIf(QuarterofYear=4,WeekOfYear-39,WeekOfYear)))
AS WeekOfQuarter,

So, now have when a given employee should be working on
a given task.

But I still need to allocate the "OtherHrs" evenly
throughout the 13/14 weeks of the quarter. How does
one go about doing this? I have done the division, but
my query only includes those records where WorkingDate
exists. I need to see that every employee is doing 1/13th
of their work in every week. Please help.