If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
subreport Calc error
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How To Change default error messages | Rich1234 | Using Forms | 7 | March 28th, 2006 12:54 AM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
Outlook 2002 Error (Several Installations) | RDBrimmer | General Discussion | 3 | June 29th, 2005 10:40 AM |
Subreport causes ODBC error | Andrew Proctor | Setting Up & Running Reports | 0 | June 22nd, 2005 03:58 PM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |