Adding the Total Days Generated by the DateDiff Function

  • Thread starter Thread starter phm
  • Start date Start date
P

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!!!
 
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)
 
Do not use 'TheTextBoxNameFromDetailSection' but the orignal formula.
=DateDiff("d",[to_plm],[from_plm])
 
Well; it worked. Thank you so much.
--
phm


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


phm said:
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!!!
Click to expand...
Click to expand...
 
Back
Top