Hello all!
I have a very simple statement on a report which reads:
=Sum(IIf([Current_Category]="A" & [Response_Met]=1,1,0))
This is to provide a count of those records in a table where the category is A and the response time has been met (=1). Perhaps I have overlooked something, or haven't got the syntax quite right, but does anyone know why zero is returned, when the number of records should be more than this?
Thanks.
I have a very simple statement on a report which reads:
=Sum(IIf([Current_Category]="A" & [Response_Met]=1,1,0))
This is to provide a count of those records in a table where the category is A and the response time has been met (=1). Perhaps I have overlooked something, or haven't got the syntax quite right, but does anyone know why zero is returned, when the number of records should be more than this?
Thanks.
