Counting Chk Boxes

[Guest]

Hello,

In my report I have several chkbox's that I count to give a total number for
each one.

So it would look like this:

David Ehrenreich
123-45-6789

Visited Support Center Completed Daily Worksheet Completed Season
3 6
3

Each of those are chkbox's and the -1's are counted for each one.

All, that works fine, but what I would like to add to this is a text box
that counts the totals and if the total is greater then 4 for all of them
together. The text box says accecpted.

Any help would be great.
David

 

[fredg]

Hello,

In my report I have several chkbox's that I count to give a total number for
each one.

So it would look like this:

David Ehrenreich
123-45-6789

Visited Support Center Completed Daily Worksheet Completed Season
3 6
3

Each of those are chkbox's and the -1's are counted for each one.

All, that works fine, but what I would like to add to this is a text box
that counts the totals and if the total is greater then 4 for all of them
together. The text box says accecpted.

Any help would be great.
David

Something like...

=IIf(ABS(Sum(Nz(Visited Support Center,0) + Sum([Nz(Completed Daily
Worksheet,0)+Sum(Nz(Completed Season,0) > 4,"Accepted","Not
Accepted"))

 

[Guest]

Hello Fredg,
I have been playing with the code you sent, but i am not able to get it to
work. I tried many variations and still not lucky. I keep getting an error
that says "The expression you entered has a function containing the wrong
number of arguments."

This is your code with the the actual Chkbox names
=IIf(ABS(Sum(Nz(ACA,0) + Sum(Nz(ADV,0)+Sum(Nz(CC,0) > 4,"Accepted","Not
Accepted"))

Thank You, Again
David

Hello,

In my report I have several chkbox's that I count to give a total number for
each one.

So it would look like this:

David Ehrenreich
123-45-6789

Visited Support Center Completed Daily Worksheet Completed Season
3 6
3

Each of those are chkbox's and the -1's are counted for each one.

All, that works fine, but what I would like to add to this is a text box
that counts the totals and if the total is greater then 4 for all of them
together. The text box says accecpted.

Any help would be great.
David

Something like...

=IIf(ABS(Sum(Nz(Visited Support Center,0) + Sum([Nz(Completed Daily
Worksheet,0)+Sum(Nz(Completed Season,0) > 4,"Accepted","Not
Accepted"))

 

[Duane Hookom]

Try count the number of "(" and the number of ")". They should be the same.
It looks like you have three "Sum("s with no ")".
--
Duane Hookom
MS Access MVP
--

Hello Fredg,
I have been playing with the code you sent, but i am not able to get it to
work. I tried many variations and still not lucky. I keep getting an
error
that says "The expression you entered has a function containing the wrong
number of arguments."

This is your code with the the actual Chkbox names
=IIf(ABS(Sum(Nz(ACA,0) + Sum(Nz(ADV,0)+Sum(Nz(CC,0) > 4,"Accepted","Not
Accepted"))

Thank You, Again
David

Hello,

In my report I have several chkbox's that I count to give a total
number for
each one.

So it would look like this:

David Ehrenreich
123-45-6789

Visited Support Center Completed Daily Worksheet Completed
Season
3 6
3

Each of those are chkbox's and the -1's are counted for each one.

All, that works fine, but what I would like to add to this is a text
box
that counts the totals and if the total is greater then 4 for all of
them
together. The text box says accecpted.

Any help would be great.
David

Something like...

=IIf(ABS(Sum(Nz(Visited Support Center,0) + Sum([Nz(Completed Daily
Worksheet,0)+Sum(Nz(Completed Season,0) > 4,"Accepted","Not
Accepted"))

 

[Guest]

Duane,

I tried many variations, but no luck.
=IIf(ABS(Sum(Nz([ACA],0) ) + Sum(Nz([ADV],0)) + Sum(Nz([CC],0)) >
4,"Accepted","Not"))

=IIf(ABS(Sum(Nz(ACA,0) ) AND Sum(Nz(ADV,0)) AND Sum(Nz(CC,0)) >
4,"Accepted","Not Accecpted"))

Etc...
I never tried this so I'm learning

Thank You,
David
"

Try count the number of "(" and the number of ")". They should be the same.
It looks like you have three "Sum("s with no ")".
--
Duane Hookom
MS Access MVP
--

Hello Fredg,
I have been playing with the code you sent, but i am not able to get it to
work. I tried many variations and still not lucky. I keep getting an
error
that says "The expression you entered has a function containing the wrong
number of arguments."

This is your code with the the actual Chkbox names
=IIf(ABS(Sum(Nz(ACA,0) + Sum(Nz(ADV,0)+Sum(Nz(CC,0) > 4,"Accepted","Not
Accepted"))

Thank You, Again
David

On Thu, 15 Sep 2005 10:23:02 -0700, David wrote:

Hello,

In my report I have several chkbox's that I count to give a total
number for
each one.

So it would look like this:

David Ehrenreich
123-45-6789

Visited Support Center Completed Daily Worksheet Completed
Season
3 6
3

Each of those are chkbox's and the -1's are counted for each one.

All, that works fine, but what I would like to add to this is a text
box
that counts the totals and if the total is greater then 4 for all of
them
together. The text box says accecpted.

Any help would be great.
David

Something like...

=IIf(ABS(Sum(Nz(Visited Support Center,0) + Sum([Nz(Completed Daily
Worksheet,0)+Sum(Nz(Completed Season,0) > 4,"Accepted","Not
Accepted"))

 

[fredg]

Hello Fredg,
I have been playing with the code you sent, but i am not able to get it to
work. I tried many variations and still not lucky. I keep getting an error
that says "The expression you entered has a function containing the wrong
number of arguments."

This is your code with the the actual Chkbox names
=IIf(ABS(Sum(Nz(ACA,0) + Sum(Nz(ADV,0)+Sum(Nz(CC,0) > 4,"Accepted","Not
Accepted"))

Thank You, Again
David

Hello,

In my report I have several chkbox's that I count to give a total number for
each one.

So it would look like this:

David Ehrenreich
123-45-6789

Visited Support Center Completed Daily Worksheet Completed Season
3 6
3

Each of those are chkbox's and the -1's are counted for each one.

All, that works fine, but what I would like to add to this is a text box
that counts the totals and if the total is greater then 4 for all of them
together. The text box says accecpted.

Any help would be great.
David

Something like...

=IIf(ABS(Sum(Nz(Visited Support Center,0) + Sum([Nz(Completed Daily
Worksheet,0)+Sum(Nz(Completed Season,0) > 4,"Accepted","Not
Accepted"))

I goofed with the placement of the parenthesis.
And I didn't notice you had spaces in the field names.
Try this:

=IIf(ABS(Sum(Nz([Visited Support Center],0)) + Sum(Nz([Completed Daily
Worksheet],0))+Sum(Nz([Completed Season],0)) > 4,"Accepted","Not
Accepted"))