Query Running Sum with no Values

[Vasago]

I have a query that I am trying to get my employees weekly hours running sum. That way I can seperate the overtime hours and properly calculate profits. I am using a dsum() to add employee time if it is the same week number.

I am not getting any results for Running total.

Running Total: DSum("[time]","Profit Breakdown 1","[Week] = " & [week number] & " And  DatePart('d', [Date]) <= " & [ddate] & "")

Week number: Format([date],"ww")

Week: Format([Date],"ww")

ddate: DatePart('d',[date])

I am modeling this from this example:

http://support.microsoft.com/kb/290136

[Vasago]

Update:

I was able to get it to calculate correct with this

Running Total: (DSum("[time]","Profit Breakdown 1","[Week] = " & [week number] & " And  DatePart('d', [Date]) <= " & [ddate] & " And [Employee]='" & [Employee1] & "'")/60)

But it only Calculating it for about 1/2 of the entries. I double checked the empty ones to make sure [Employee] and [Employee1], and dates match. The all look ok but still having issues.

[Vasago]

I have found the issue. I need to run Dsum in a new Query.