textbox calculations

  • Thread starter Thread starter talib
  • Start date Start date
T

talib

in an access 2000 report i am attempting to get the total
number of yes responses in a textbox. the field is a
yes/no field with a combo box and a value list with
yes;no. any help will be greatly appreciated. thanks
 
talib said:
in an access 2000 report i am attempting to get the total
number of yes responses in a textbox. the field is a
yes/no field with a combo box and a value list with
yes;no.
Click to expand...


I don't know what a "field is a yes/no field with a combo
box and a value list" is, but one or the other of these
expressions will probably work:

=Abs(Sum(yesnofield))
or
=Abs(Sum(yesnofield = "Yes"))

This totals text box must be in a group footer or the report
footer.
 
I would suggest storing a number either -1 or 1 for yes and 0 for no. You
can then just sum the field. However, if you are storing "Yes" or "No" text
values, you can use:
=Sum(Abs([FieldName] = "Yes"))
 
Back
Top