Count Only Yes Records on Report

  • Thread starter Thread starter Ann
  • Start date Start date
A

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!!!!
 
=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
 
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!!!!
.
Click to expand...
.
Click to expand...
 
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!!!!
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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 said:
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!!!!
.

.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top