Sum Check Box

[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

 

[KARL DEWEY]

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]))

 

[Humbled Learner]

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

 

[KARL DEWEY]

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

--
Build a little, test a little.

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

 

[Humbled Learner]

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

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

--
Build a little, test a little.

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

 

[KARL DEWEY]

When I setup the query, should I use the sum feature?
Yes.
--
Build a little, test a little.

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

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

--
Build a little, test a little.

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