Conditional Count

[AuditorCMM]

I have a database of employee complaints and need to add a field to the
report that will count all complaints still under investigation that are
older than 60 days. Our "Action Taken" field is where we indicate "In
Process". I set up the following expression, but it did not work:

IIf(([Action Taken]="In Process") AND ((Now( ) - [Incident
Date])>60)),Count([Action Taken]),"N/A")

I also tried just setting up the formula to count those in process
(regardless of date) by eliminating the date calculation above and it still
didn't work.

Could someone tell me where the error is stemming from. Or if I'm way off
base, does anyone know what type of formula I could use?

Thanks!!

 

[Ofer Cohen]

Try

Sum(IIf([Action Taken]="In Process" AND (Date( ) - [Incident Date])>60 ,1,0))

 

[AuditorCMM]

That worked perfectly. Thanks so much!

Try

Sum(IIf([Action Taken]="In Process" AND (Date( ) - [Incident Date])>60 ,1,0))

--
Good Luck
BS"D

I have a database of employee complaints and need to add a field to the
report that will count all complaints still under investigation that are
older than 60 days. Our "Action Taken" field is where we indicate "In
Process". I set up the following expression, but it did not work:

IIf(([Action Taken]="In Process") AND ((Now( ) - [Incident
Date])>60)),Count([Action Taken]),"N/A")

I also tried just setting up the formula to count those in process
(regardless of date) by eliminating the date calculation above and it still
didn't work.

Could someone tell me where the error is stemming from. Or if I'm way off
base, does anyone know what type of formula I could use?

Thanks!!

 

[cuthies ict]

I have a database of employee complaints and need to add a field to the
report that will count all complaints still under investigation that are
older than 60 days. Our "Action Taken" field is where we indicate "In
Process". I set up the following expression, but it did not work:

IIf(([Action Taken]="In Process") AND ((Now( ) - [Incident
Date])>60)),Count([Action Taken]),"N/A")

I also tried just setting up the formula to count those in process
(regardless of date) by eliminating the date calculation above and it still
didn't work.

Could someone tell me where the error is stemming from. Or if I'm way off
base, does anyone know what type of formula I could use?

Thanks!!