C
chopper57 via AccessMonster.com
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]
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]