Statement

[lmossolle]

Could someone please assist with this?

I would like to count the y's in a complete field and then subtract it from
the awarddays field. Where assigned = Carla.

=Sum(IIf([complete]-[awarddays],1,0))

Thanks

 

[John Spencer]

= Abs(SUM([Complete]="Y" and [Assigned] = "Carla") ) - Abs(Sum([Assigned] =
"Carla" * [AwardDays]))

Perhaps you could post a few records and then what you expect to see as the
result.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..