Calculation On a Form

[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

 

[Bruce M. Thompson]

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,

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)

 

[Fredg]

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.

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,

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)

 

[Ken Snell]

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>

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.

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,

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

within the newsgroups so that all might benefit.<<

 

[Bruce M. Thompson]

And here I have been thinking it's my Outlook Express that drops

parentheses....guess I need to blame it on MY ISP! < g >

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

;-)

 

[Ken Snell]

< snort snort ! >
;-)