How to total my DateDiff Field in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcy@airproducts - 02 Dec 2005 18:34 GMT

In my report I need to total my DateDiff field (=DateDiff("d",[Date
Rejected],[Date Completed]) in the header. It is a number of days, but when
I try =Sum([DateDiff("d",[Date Rejected],[Date Completed])]) the expression
is too complicated. How can I get my report to total all the days?

Reply to this Message

Marshall Barton - 02 Dec 2005 21:18 GMT

"Marcy@airproducts"

>In my report I need to total my DateDiff field (=DateDiff("d",[Date
>Rejected],[Date Completed]) in the header. It is a number of days, but when
>I try =Sum([DateDiff("d",[Date Rejected],[Date Completed])]) the expression
>is too complicated. How can I get my report to total all the days?

There is an extra ] in that expression.

Also make sure that [Date Rejected] and [Date Completed] are
**fields** in the report's record source table/query and not
controls on the report.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Marcy@airproducts - 02 Dec 2005 21:26 GMT

Thank you, right after sending this message I caught the error!

> "Marcy@airproducts"
>
[quoted text clipped - 8 lines]
> **fields** in the report's record source table/query and not
> controls on the report.

Reply to this Message