DateDiff

[bdehning]

I have a report with the following: =DateDiff("d",[Call Date],[Rpt Date])
which shows me the number of days between the two dates located in Text Box
with name text29 for many records.

If in this report I now want to count the number of times that this
difference is more than 10 days in a footer is it possible and how do I do
it.???

 

[Al Camp]

In the query behind the form, create a calculated field like this...
Over10 : IIF(DateDiff("d",[Call Date],[Rpt Date])>10,1,0)
Then sum Over10 in any footer.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[bdehning]

Ok That worked Great.

Now if I want to calculate the % of Those more than 10 days what do I do.

My query only contains the total number and you helped with the field for
those more than 10. How do I get a field for total query records?

I assume 2 fields from query..
--
Brian

In the query behind the form, create a calculated field like this...
Over10 : IIF(DateDiff("d",[Call Date],[Rpt Date])>10,1,0)
Then sum Over10 in any footer.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a report with the following: =DateDiff("d",[Call Date],[Rpt Date])
which shows me the number of days between the two dates located in Text
Box
with name text29 for many records.

If in this report I now want to count the number of times that this
difference is more than 10 days in a footer is it possible and how do I
do
it.???

 

[bdehning]

I got it all to work. Thanks for the help
--
Brian

Ok That worked Great.

Now if I want to calculate the % of Those more than 10 days what do I do.

My query only contains the total number and you helped with the field for
those more than 10. How do I get a field for total query records?

I assume 2 fields from query..
--
Brian

In the query behind the form, create a calculated field like this...
Over10 : IIF(DateDiff("d",[Call Date],[Rpt Date])>10,1,0)
Then sum Over10 in any footer.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a report with the following: =DateDiff("d",[Call Date],[Rpt Date])
which shows me the number of days between the two dates located in Text
Box
with name text29 for many records.

If in this report I now want to count the number of times that this
difference is more than 10 days in a footer is it possible and how do I
do
it.???