Calculation On a Form

  • Thread starter Thread starter Robert Gillard
  • Start date Start date
R

Robert Gillard

I have a form based on a query, One field [accepted] is a Yes / No field it
views as "yes" "no" when you look at the table. I merely wish to have a
total of Yes and a total of No's appear on the form. How do I do this
please,

Bob
 
I have a form based on a query, One field [accepted] is a Yes / No field it
views as "yes" "no" when you look at the table. I merely wish to have a
total of Yes and a total of No's appear on the form. How do I do this
please,
Click to expand...

In the section or form's footer, try placing 2 text boxes and use the following
for the "Control Source" property of each text box:

For the total count of "Yes":
=Abs(Sum([accepted])

For the total count of "No":
=Sum([accepted] + 1)
 
I don't want to appear picky, Bruce, but I think your ISP dropped a
parentheses after you clicked send. I'm not surprised, as my ISP does that
to me all the time also. :-)

It should be:
=Abs(Sum([accepted]))

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Bruce M. Thompson said:
I have a form based on a query, One field [accepted] is a Yes / No field it
views as "yes" "no" when you look at the table. I merely wish to have a
total of Yes and a total of No's appear on the form. How do I do this
please,
Click to expand...

In the section or form's footer, try placing 2 text boxes and use the following
for the "Control Source" property of each text box:

For the total count of "Yes":
=Abs(Sum([accepted])

For the total count of "No":
=Sum([accepted] + 1)
Click to expand...
 
And here I have been thinking it's my Outlook Express that drops
parentheses....guess I need to blame it on MY ISP! < g >

--
Ken Snell
<MS ACCESS MVP>

Fredg said:
I don't want to appear picky, Bruce, but I think your ISP dropped a
parentheses after you clicked send. I'm not surprised, as my ISP does that
to me all the time also. :-)

It should be:
=Abs(Sum([accepted]))

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Bruce M. Thompson said:
I have a form based on a query, One field [accepted] is a Yes / No
Click to expand...
Click to expand...
field
it
views as "yes" "no" when you look at the table. I merely wish to have a
total of Yes and a total of No's appear on the form. How do I do this
please,
Click to expand...

In the section or form's footer, try placing 2 text boxes and use the following
for the "Control Source" property of each text box:

For the total count of "Yes":
=Abs(Sum([accepted])

For the total count of "No":
=Sum([accepted] + 1)

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications
Click to expand...
within the newsgroups so that all might benefit.<<
Click to expand...
Click to expand...
 
And here I have been thinking it's my Outlook Express that drops
parentheses....guess I need to blame it on MY ISP! < g >
Click to expand...

Actually, it's OE that drops brackets in sql statements. <snort>

;-)
 
Back
Top