Trouble with IIf and And

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

Guest

In a report I am trying to develop a formula involving 3 fields; Young Adult
(text), Length of Contact (number) and Group Activity (check box). I am
currently counting Length of Contact for the young adults using:

=Sum(IIf([Name of Child]="Mr. Smith",[Length of Contact],0))

I want to develop a formula that only counts Length of Contact when Group
Activity is not checked.

I appreciate any and all help. Thanks.
 
=Sum(IIf([Name of Child]="Mr. Smith" AND [Group Activity] = False,[Length of
Contact],0))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Thanks that worked like a charm. As the kids would say; "you got sick
skills" [that now means good!] Thanks again.

John Spencer said:
=Sum(IIf([Name of Child]="Mr. Smith" AND [Group Activity] = False,[Length of
Contact],0))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Nick CWT said:
In a report I am trying to develop a formula involving 3 fields; Young
Adult
(text), Length of Contact (number) and Group Activity (check box). I am
currently counting Length of Contact for the young adults using:

=Sum(IIf([Name of Child]="Mr. Smith",[Length of Contact],0))

I want to develop a formula that only counts Length of Contact when Group
Activity is not checked.

I appreciate any and all help. Thanks.
Click to expand...
Click to expand...
 
Back
Top