DSUM output strange (1 Viewer)

[AngelicGuardian]

I am using a DSUM in a report to calculate a total number of hours worked...
This is the Data I'm trying to computate:

ID FileNo Date Worker Hours
197708 1005F 6/1/2004 DJC 1.5
197709 1001F 6/1/2004 DJC 2.5
197710 20162 6/1/2004 DJC 1.5
197711 1004F 6/1/2004 DJC 1.5
197712 1002F 6/1/2004 DJC 0.5
197713 30318 6/2/2004 DJC 0.5
197714 20130 6/2/2004 DJC 2.5
197715 1001F 6/2/2004 DJC 2
197716 20130 6/2/2004 DJC 1.75
197717 1002F 6/2/2004 DJC 0.5

The Total Number of Hours is: 14.75

Every time I call a DSUM specifing the range of data as shown above in a report I get a return of 25
even if I use =DSum([Hours],"tbillHours","[ID] >= 197708 And [ID] <= 197717 And [Worker] = 'DJC')
if I call DSUM with the same arguments in a VB Form i get a return of 15.
What is the deal with The Report?? And how do I fix it??

Thanks,
Zack

 

[Rich]

Why not just =Sum([Hours]) in the Group or Report footer?

 

[AngelicGuardian]

Why not just =Sum([Hours]) in the Group or Report footer?

Because It needs to be versatile I'm going to need to add a total for it based on another field record called HourTypes
I need to add OpenOffice Hours only and Client Hours in different areas

 

[Rich]

Sum(Iif([HoursType]="OpenOffice",[HoursType],0))