Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lmossolle - 24 Mar 2008 13:49 GMT

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

Reply to this Message

John Spencer - 24 Mar 2008 18:52 GMT

= 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.

Signature

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

> Could someone please assist with this?
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message