B
Bruce
I have an Access Database in Office 97. In a Report based on a Query I need
to calculate how many cases there are that fall in "Segment 1" and have a
tick in a check box in field Enq Not Taken Up.
That is my attempt below, it doesn't work although if I keep each question
seperatley it does i.e.
=Sum(Abs([Enq Not Taken Up]))
=Sum(Abs([PRC]="Segment 1"))
=Sum(Abs([Enq Not Taken Up] & (Abs([PRC]="Segment 1"))))
How can this be achieved?
Thanks
Bruce
to calculate how many cases there are that fall in "Segment 1" and have a
tick in a check box in field Enq Not Taken Up.
That is my attempt below, it doesn't work although if I keep each question
seperatley it does i.e.
=Sum(Abs([Enq Not Taken Up]))
=Sum(Abs([PRC]="Segment 1"))
=Sum(Abs([Enq Not Taken Up] & (Abs([PRC]="Segment 1"))))
How can this be achieved?
Thanks
Bruce