Sum in Report

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
 
Top