subreport Calc error

The problem on my report is to show Previous Hours when no Hours are entered.
Previous Hours works fine as long as there is one entry or more. Need it to
work with no entries. Previous Hours is a subreport.

Previous Hours on Main Report
=[subrpt_AccumutiveHours].Report.AccumutiveTotal-[subrpt_CalcHours].Report.
[Hours Grand Total Sum]

subrpt_AccumutiveHours – AccumutiveTotal Control Source is:
Accumative Total is running total of hours from all records
=Sum([Hours])

subrpt CalcHours Hours – HoursTotalSum Control Source is:
HoursTotalSum is total hours from last record entered (could be no hours when
no work performed)
=Sum([Hours])

“Hours” in the subrpt’s comes from a query with the following formula:
Hours: IIf([Finish][Start],([Finish]-[Start])*24,24-([Start]-[Finish])*24)-
[Breaks]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200603/1

chopper57 wrote:
The problem on my report is to show Previous Hours when no Hours are entered.
Previous Hours works fine as long as there is one entry or more. Need it to
work with no entries. Previous Hours is a subreport.

Previous Hours on Main Report (Needs to show the same hours as in the Accumutive)
=[subrpt_AccumutiveHours].Report.AccumutiveTotal-[subrpt_CalcHours].Report.
[Hours Grand Total Sum]

subrpt_AccumutiveHours – AccumutiveTotal Control Source is:
Accumative Total is running total of hours from all records
=Sum([Hours])

subrpt CalcHours Hours – HoursTotalSum Control Source is:
HoursTotalSum is total hours from last record entered (could be no hours when
no work performed)
=Sum([Hours])

“Hours” in the subrpt’s comes from a query with the following formula:
Hours: IIf([Finish][Start],([Finish]-[Start])*24,24-([Start]-[Finish])*24)-
[Breaks]

What I'm looking for is that the Previous hours would need to be the same as
Accumutive Hours since I would be showing a report with no hours entered.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200603/1