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
|
|||
|
|||
Running sum based on Calculation
Hiya, fellas
I've a report like this: REPORT HEADER+++++++++++++++++++++++++++ TripJob TravelDaysTotal (=Sum([TravelDays])) PAGE HEADER+++++++++++++++++++++++++++++ TRIPJOB HEADER+++++++++++++++++++++++++++ ~labels~ DETAIL++++++++++++++++++++++++++++++++++ ... StartDate EndDate TravelDays (=DateDiff("d",[StartDate],[EndDate])) ... TRIPJOB FOOTER+++++++++++++++++++++++++++ PAGE FOOTER+++++++++++++++++++++++++++++ REPORT FOOTER+++++++++++++++++++++++++++ simple enough, right? The report is opened based on the user's selection of [TripJob] from a form. When I open the report the system struggles and asks for a param value for TravelDays. Of course, the end user is not providing this data, it is calculated by the report. Clearly I've got some timing issues he how can [TravelDaysTotal] calculate [TravelDays] without the form being fully loaded, right? Thanks in advance! /amelia |
#2
|
|||
|
|||
Of course, you can't calculate controls...
so i'm using this: [TravelDaysTotal] =SUM(DateDiff("d",[StartDate],[EndDate])) works just fine. :: sigh :: /amelia "aaearhart" wrote: Hiya, fellas I've a report like this: REPORT HEADER+++++++++++++++++++++++++++ TripJob TravelDaysTotal (=Sum([TravelDays])) PAGE HEADER+++++++++++++++++++++++++++++ TRIPJOB HEADER+++++++++++++++++++++++++++ ~labels~ DETAIL++++++++++++++++++++++++++++++++++ ... StartDate EndDate TravelDays (=DateDiff("d",[StartDate],[EndDate])) ... TRIPJOB FOOTER+++++++++++++++++++++++++++ PAGE FOOTER+++++++++++++++++++++++++++++ REPORT FOOTER+++++++++++++++++++++++++++ simple enough, right? The report is opened based on the user's selection of [TripJob] from a form. When I open the report the system struggles and asks for a param value for TravelDays. Of course, the end user is not providing this data, it is calculated by the report. Clearly I've got some timing issues he how can [TravelDaysTotal] calculate [TravelDays] without the form being fully loaded, right? Thanks in advance! /amelia |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calculation based on a calculated value in a report | steely via AccessMonster.com | New Users | 2 | June 3rd, 2005 08:06 PM |
running a query based on a date that I enter | tobacey | Setting Up & Running Reports | 1 | January 28th, 2005 02:43 AM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Report Based Upon Parameter Query with Form References | Vincent DeLuca | Setting Up & Running Reports | 4 | July 19th, 2004 01:55 AM |
Installing Outook 2003 over Exhange Server Based Client running Win2K Prof and Office 2000 | joe smith | Installation & Setup | 3 | June 9th, 2004 03:44 PM |