IIf this and that then this, HELP.

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

Guest

Hello.
I am using Access 2000 and I am creating a report and I need to create a
running sum hidden field in the details section. I need to create an autosum
that will count all of the "SB" in field [Office] and that have a date in the
[TransCompleteD] field. I tried this and it it came up with a count of 2 when
there were 2 records but only one had the TransCompleteD date. How can I get
this to work?

=IIf([Office]="SB" And [TransCompleteD]="Is Null",0,1)

Thanks.
Iram/mcp
 
I have not used two criteria in an IIF but this should be a start

=IIf([Office]="SB" And IsNull([TransCompleteD]),0,1)

Tony

Iram said:
Hello.
I am using Access 2000 and I am creating a report and I need to create a
running sum hidden field in the details section. I need to create an
autosum
that will count all of the "SB" in field [Office] and that have a date in
the
[TransCompleteD] field. I tried this and it it came up with a count of 2
when
there were 2 records but only one had the TransCompleteD date. How can I
get
this to work?
Thanks.
Iram/mcp
Click to expand...
 
Back
Top