Office 97

  • Thread starter Thread starter Bruce
  • Start date Start date
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
 
Bruce,
Just put the 2 "working" statements together...
=Sum(Abs([Enq Not Taken Up])) + Sum(Abs([PRC]="Segment 1"))

The "&" character is a concatenation, not an indication of a sum.
That should do it...
 
Alternatively, if the intent is to determine how many have Enq Not Taken Up
checked AND have [PRC] = "Segment 1", you might want:

=Sum(Abs([Enq Not Taken Up] AND ([PRC]="Segment 1")))

If you wanted how many have Enq Not Taken Up checked OR have [PRC] =
"Segment 1", you'd use

=Sum(Abs([Enq Not Taken Up] OR ([PRC]="Segment 1")))

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Al Camp said:
Bruce,
Just put the 2 "working" statements together...
=Sum(Abs([Enq Not Taken Up])) + Sum(Abs([PRC]="Segment 1"))

The "&" character is a concatenation, not an indication of a sum.
That should do it...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Bruce said:
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
Click to expand...
Click to expand...
 
Back
Top