DateDiff

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.???
 
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


Al Camp said:
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 said:
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.???
Click to expand...
Click to expand...
 
I got it all to work. Thanks for the help
--
Brian


bdehning said:
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


Al Camp said:
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 said:
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.???
Click to expand...
Click to expand...
Click to expand...
 
Back
Top