DateDiff

[Guest]

I now need to know how to proceed if I have another field called
[VerbalDate]. See question below which I got to work.

But I need to do using either Rpt Date or Verbal Date. The over 10 will not
count if VerbalDate or Rpt Date is within 10 Days. Do I still use DateDIff
somehow?

Help Please.

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

 

[Guest]

Try this

Over10New: IIF(DateDiff("d",[Call Date],[VerbalDate])>10 Or
DateDiff("d",[Call Date],[Rpt Date])>10,1,0)

--
I hope that helped
Good luck

I now need to know how to proceed if I have another field called
[VerbalDate]. See question below which I got to work.

But I need to do using either Rpt Date or Verbal Date. The over 10 will not
count if VerbalDate or Rpt Date is within 10 Days. Do I still use DateDIff
somehow?

Help Please.

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