If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
Adding the Total Days Generated by the DateDiff Function
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 |
#4
|
|||
|
|||
Adding the Total Days Generated by the DateDiff Function
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 |
#5
|
|||
|
|||
Adding the Total Days Generated by the DateDiff Function
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 |
Thread Tools | |
Display Modes | |
|
|