Count Only Yes Records on Report

[Ann]

I have a report with a field called [On Track]. The
control field is a combo box that captures Yes/No. I
would like to capture a Sub total Count of only the YES
records. I've tried the following =Count([On Track]), =Sum
(ABS([On Track]), =ABS(Count([On Track])but it continues
to count all the records in the field.
Can someone tell me what I'm doing wrong. Help!!!!

 

[Fons Ponsioen]

=Sum(Abs([OnTrack]))
or
=Abs(Sum([OnTrack]))
will work, I suspect you placed the Textbox with the above
line in other than the report or group footer.
Hope this helps.
Fons

 

[Ann]

Fons,
I'm not sure what your suggestion was.
Are you saying I should not put the textbox with the

=Sum(Abs([OnTrack])) in the report or group footer?
Thanks.

-----Original Message-----
=Sum(Abs([OnTrack]))
or
=Abs(Sum([OnTrack]))
will work, I suspect you placed the Textbox with the above
line in other than the report or group footer.
Hope this helps.
Fons

-----Original Message-----
I have a report with a field called [On Track]. The
control field is a combo box that captures Yes/No. I
would like to capture a Sub total Count of only the YES
records. I've tried the following =Count([On Track]), =Sum
(ABS([On Track]), =ABS(Count([On Track])but it continues
to count all the records in the field.
Can someone tell me what I'm doing wrong. Help!!!!
.

.

 

[Ann]

I have the text box with =Sum(abs([ on track]) in the
group summary field and report footer. It's giving me an
error message expression is too complicated to be
evaluated. Help... thanks.

-----Original Message-----
Fons,
I'm not sure what your suggestion was.
Are you saying I should not put the textbox with the

=Sum(Abs([OnTrack])) in the report or group footer?
Thanks.

-----Original Message-----
=Sum(Abs([OnTrack]))
or
=Abs(Sum([OnTrack]))
will work, I suspect you placed the Textbox with the above
line in other than the report or group footer.
Hope this helps.
Fons

-----Original Message-----
I have a report with a field called [On Track]. The
control field is a combo box that captures Yes/No. I
would like to capture a Sub total Count of only the YES
records. I've tried the following =Count([On Track]), =Sum
(ABS([On Track]), =ABS(Count([On Track])but it continues
to count all the records in the field.
Can someone tell me what I'm doing wrong. Help!!!!
.

.

.

 

[SA]

Ann:

Normally what might cause this to error as being too complex is if the field
OnTrack might have null values rather than 0 or -1. Test that field in the
data for Is Null. If there are null values then use an update query to set
them to 0 and change the field in the table to default to 0
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I have the text box with =Sum(abs([ on track]) in the
group summary field and report footer. It's giving me an
error message expression is too complicated to be
evaluated. Help... thanks.

-----Original Message-----
Fons,
I'm not sure what your suggestion was.
Are you saying I should not put the textbox with the

=Sum(Abs([OnTrack])) in the report or group footer?
Thanks.

-----Original Message-----
=Sum(Abs([OnTrack]))
or
=Abs(Sum([OnTrack]))
will work, I suspect you placed the Textbox with the above
line in other than the report or group footer.
Hope this helps.
Fons
-----Original Message-----
I have a report with a field called [On Track]. The
control field is a combo box that captures Yes/No. I
would like to capture a Sub total Count of only the YES
records. I've tried the following =Count([On Track]), =Sum
(ABS([On Track]), =ABS(Count([On Track])but it continues
to count all the records in the field.
Can someone tell me what I'm doing wrong. Help!!!!
.

.

.