Count Only Yes Records on Report

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!!!!

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

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

.

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

.

.

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

"Ann" wrote in message
...
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!!!!
.

.

.