Running sum based on Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 here: how can
[TravelDaysTotal] calculate [TravelDays] without the form being fully loaded,
right?

Thanks in advance!
/amelia
 
Of course, you can't calculate controls...

so i'm using this:

[TravelDaysTotal] =SUM(DateDiff("d",[StartDate],[EndDate]))

works just fine.

:: sigh ::

/amelia
 
Back
Top