Adding the Total Days Generated by the DateDiff Function

[phm]

Hello,
I have created an Access report with columns containing the following
DateDiff Function: =DateDiff("d",[to_plm],[from_plm]), exact code for one of
the columns. There is a total of seven columns with different date intervals
to find.

With the DateDiff Function, within the appropriate column, the difference
between the two dates is given; however, so far, I have not been able to
total these columns. I have tried the following the the Report Footer:

=[TheTextBoxNameFromDetailSection] and enabling the "Running Sum" property
Over Group. This one gives me a number; but, it is incorrect.

I have also tried the =Sum and =Count functions. With both of these
functions, the report generates a dialog box with a "Enter Parameter Value"
message.

PLEASE HELP!!!

 

[Steve]

Keep what you have and change your query to a Totals query. Click on the
Sigma button (looks like a capital E) in the menu at the top of the screen.
Then change Group By to Sum in all seven fields.

Steve
(e-mail address removed)

 

[KARL DEWEY]

Do not use 'TheTextBoxNameFromDetailSection' but the orignal formula.
=DateDiff("d",[to_plm],[from_plm])

 

[KARL DEWEY]

Correction --
=Sum(DateDiff("d",[to_plm],[from_plm]))

 

[phm]

Well; it worked. Thank you so much.
--
phm

Correction --
=Sum(DateDiff("d",[to_plm],[from_plm]))
--
Build a little, test a little.

Hello,
I have created an Access report with columns containing the following
DateDiff Function: =DateDiff("d",[to_plm],[from_plm]), exact code for one of
the columns. There is a total of seven columns with different date intervals
to find.

With the DateDiff Function, within the appropriate column, the difference
between the two dates is given; however, so far, I have not been able to
total these columns. I have tried the following the the Report Footer:

=[TheTextBoxNameFromDetailSection] and enabling the "Running Sum" property
Over Group. This one gives me a number; but, it is incorrect.

I have also tried the =Sum and =Count functions. With both of these
functions, the report generates a dialog box with a "Enter Parameter Value"
message.

PLEASE HELP!!!