Adding the Total Days Generated by the DateDiff Function

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!!!
--
phm

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



"phm" wrote in message
...
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!!!
--
phm

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


"phm" wrote:

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!!!
--
phm

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


"phm" wrote:

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!!!
--
phm

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


"KARL DEWEY" wrote:

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


"phm" wrote:

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!!!
--
phm