Running sum based on Calculation

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
 
G

Guest

Of course, you can't calculate controls...

so i'm using this:

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

works just fine.

:: sigh ::

/amelia
 

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