subreport Calc error

  • Thread starter chopper57 via AccessMonster.com
  • Start date
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]
 
C

chopper57 via AccessMonster.com

chopper57 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top