Counting Chk Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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"))
 
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
fredg said:
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
Click to expand...

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"))
Click to expand...
 
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
--


David said:
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
fredg said:
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
Click to expand...

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"))
Click to expand...
Click to expand...
 
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
"
Duane said:
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
--


David said:
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
fredg said:
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"))
Click to expand...
Click to expand...
Click to expand...
 
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
fredg said:
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
Click to expand...

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"))
Click to expand...
Click to expand...

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"))
 
Back
Top