Sum Check Box

  • Thread starter Thread starter Humbled Learner
  • Start date Start date
H

Humbled Learner

I checked the history and I"m just not getting this one... please advise...

Form one has check box called Error 1
Form two has check box Error 2

I would like to open a report that shows how many errors 1 (if checked) vs
how many errors 2 (if checked)
and form 2 teh number of check boxes.

Is this something I need to do in query like criteria or can I just make a
form from the tables and have the totals?

I've tried =Sum(IIf([SUM Of BUY],1,0)) and =Abs(Sum([Order])) and neither
will result in numbers

Everything I try, I get a check box on the report or yes or no... I just
want numbers...

(access 2003)

Thank You
 
What are the field names that store your check boxes. I do not think that
[SUM Of BUY] would be the name for a check box but possibly [Order].
Check boxes store a -1 so this will total --
Abs(Sum([SomeField]))
 
Field names are FDA Error and FDA Error 2... is it a query thing or a report
thing?
--
Thank You


KARL DEWEY said:
What are the field names that store your check boxes. I do not think that
[SUM Of BUY] would be the name for a check box but possibly [Order].
Check boxes store a -1 so this will total --
Abs(Sum([SomeField]))

--
Build a little, test a little.


Humbled Learner said:
I checked the history and I"m just not getting this one... please advise...

Form one has check box called Error 1
Form two has check box Error 2

I would like to open a report that shows how many errors 1 (if checked) vs
how many errors 2 (if checked)
and form 2 teh number of check boxes.

Is this something I need to do in query like criteria or can I just make a
form from the tables and have the totals?

I've tried =Sum(IIf([SUM Of BUY],1,0)) and =Abs(Sum([Order])) and neither
will result in numbers

Everything I try, I get a check box on the report or yes or no... I just
want numbers...

(access 2003)

Thank You
Click to expand...
Click to expand...
 
Do you have a Totals query feeding the report?
Use this in the query --
Abs(Sum([SomeField]))

--
Build a little, test a little.


Humbled Learner said:
Field names are FDA Error and FDA Error 2... is it a query thing or a report
thing?
--
Thank You


KARL DEWEY said:
What are the field names that store your check boxes. I do not think that
[SUM Of BUY] would be the name for a check box but possibly [Order].
Check boxes store a -1 so this will total --
Abs(Sum([SomeField]))

--
Build a little, test a little.


Humbled Learner said:
I checked the history and I"m just not getting this one... please advise...

Form one has check box called Error 1
Form two has check box Error 2

I would like to open a report that shows how many errors 1 (if checked) vs
how many errors 2 (if checked)
and form 2 teh number of check boxes.

Is this something I need to do in query like criteria or can I just make a
form from the tables and have the totals?

I've tried =Sum(IIf([SUM Of BUY],1,0)) and =Abs(Sum([Order])) and neither
will result in numbers

Everything I try, I get a check box on the report or yes or no... I just
want numbers...

(access 2003)

Thank You
Click to expand...
Click to expand...
Click to expand...
 
I've tried that, the report still shows YES for each line I used for testing...

When I setup the query, should I use the sum feature?

Thank You


KARL DEWEY said:
Do you have a Totals query feeding the report?
Use this in the query --
Abs(Sum([SomeField]))

--
Build a little, test a little.


Humbled Learner said:
Field names are FDA Error and FDA Error 2... is it a query thing or a report
thing?
--
Thank You


KARL DEWEY said:
What are the field names that store your check boxes. I do not think that
[SUM Of BUY] would be the name for a check box but possibly [Order].
Check boxes store a -1 so this will total --
Abs(Sum([SomeField]))

--
Build a little, test a little.


:

I checked the history and I"m just not getting this one... please advise...

Form one has check box called Error 1
Form two has check box Error 2

I would like to open a report that shows how many errors 1 (if checked) vs
how many errors 2 (if checked)
and form 2 teh number of check boxes.

Is this something I need to do in query like criteria or can I just make a
form from the tables and have the totals?

I've tried =Sum(IIf([SUM Of BUY],1,0)) and =Abs(Sum([Order])) and neither
will result in numbers

Everything I try, I get a check box on the report or yes or no... I just
want numbers...

(access 2003)

Thank You
Click to expand...
Click to expand...
Click to expand...
 
When I setup the query, should I use the sum feature?
Yes.
--
Build a little, test a little.


Humbled Learner said:
I've tried that, the report still shows YES for each line I used for testing...

When I setup the query, should I use the sum feature?

Thank You


KARL DEWEY said:
Do you have a Totals query feeding the report?
Use this in the query --
Abs(Sum([SomeField]))

--
Build a little, test a little.


Humbled Learner said:
Field names are FDA Error and FDA Error 2... is it a query thing or a report
thing?
--
Thank You


:

What are the field names that store your check boxes. I do not think that
[SUM Of BUY] would be the name for a check box but possibly [Order].
Check boxes store a -1 so this will total --
Abs(Sum([SomeField]))

--
Build a little, test a little.


:

I checked the history and I"m just not getting this one... please advise...

Form one has check box called Error 1
Form two has check box Error 2

I would like to open a report that shows how many errors 1 (if checked) vs
how many errors 2 (if checked)
and form 2 teh number of check boxes.

Is this something I need to do in query like criteria or can I just make a
form from the tables and have the totals?

I've tried =Sum(IIf([SUM Of BUY],1,0)) and =Abs(Sum([Order])) and neither
will result in numbers

Everything I try, I get a check box on the report or yes or no... I just
want numbers...

(access 2003)

Thank You
Click to expand...
Click to expand...
Click to expand...
 
Back
Top