Check Box's on a Report

[kentwoodjean]

I always seem to have trouble with this and it turns out differently each time I try to get a sum total of my check box's on a report.

I currently have 5 columns (categories) of numbers in a report, with the 6th column represented by a check box, clicked if it is yes. My query was set to group everything. i created my report by using the report wizard in order to get a daily total (summary not detail)for each category/column. My 6th column (check box) just says yes or no rather than providing me a positive number. I am not sure if something more should have been done to the query or if something more needs to be done to the properties box for the check box control. Can someone please help me with this? Below is how my report is set up:


Daily Count of Incoming Mail
Date gen Misd Cle DOL PA250 Blend Total WkOrder
1/2/2003 2 1 1 0 1 0 5 Yes
1/3/2003 2 1 0 0 0 0 3 Yes
1/6/2003 1 1 1 0 1 0 4 Yes
1/7/2003 1 0 1 0 1 0 3 Yes
1/8/2003 1 2 1 0 1 0 5 Yes
1/10/2003 2 0 1 0 0 0 3 Yes
1/13/2003 2 1 1 0 0 0 4 Yes
1/14/2003 1 0 2 0 1 0 4 Yes

 

[GingerR]

i'm a little confused.
do you mean the 'check box' doesnt look like a check box on the report and instead it is just the word "YES"? if this is the case then simply use the toolbox to add a check box to your report, and set it's control source to the field it represents.
if not...
is your checkbox coming from a field in your query?
what is it's expression?
what are you expecting it to look like that is diff than it is now?

 

[kentwoodjean]

Sorry I wasn't clearer.
I want it to be a number. On a given day, multiple forms can be filled out (1 for each customer) and several of those forms can have the Box "blend" checked. Since the numeric entires for categories are totaled or summarized for each day, I also want a numberic entry for the number of times the "Blend Box" is checked.

 

[GingerR]

ok i think i got it.
since YES = -1 (and NO = 0) you can use SUM in a group for it. i'm still not completely sure how you have this whole thing set up, i.e. is the report based on a table? or on a query? i think on a totals query by what you originally said, so for that field, make the TOTALS portion of that field by SUM instead of GROUP BY. then on the report you can make the text box

=-[FieldName]

since i.e. if there are two checked, the sum will be -2, so you want it to report '2'. does this make sense? i did this in both a totals query and a report, and both worked as i thought, summing the YES's, considering each to be equal to -1.

i hope i am understanding what you are talking about. if not, steer me in a better direction and we'll figure it out.

thanks--g