Tallying totals...

[stags]

Ok...sounds like we are getting somewhere but here is the whole situation. I
made a form which evaluates People for a board member position. The form I
made includes the person's name, address, city, state, zip, company working
for, position there (all of which are text boxes), or if retired (a checkbox)
and then there are several sections of different groupings of attributes
which have a just checkbox (which are all formatted as yes/no) which if the
rest of the board thinks the person has then it is checked. Now my question
is: Is there a way to get a total of each of those attributes from all the
records. (i.e. if two of more people have a check mark beside the "Government
Contacts" field then when I run something to total it all, it will show that
there are atleast 2 people. Its basically a quick tally of the total number
of skills that the board possess and it will show which skills/attributes
that they will need to look for in future candidates. If you need more
information let me know.

Thanks.

I understand that they have values but is there a way to add them up
automatically like a calculation or an expression which then returns a total
value for a column?

Yes, several ways; you can use a Totals query - base a Query on your
table and change it to a Totals query by clicking the Greek Sigma icon
(looks like a sideways M). Or, you can base a continuous Form on the
table - or on a query selecting desired records from the table - and
put a textbox in the form Footer with a control source

=-Sum([yesnofield])

to display the count of YES answers.

It's not completely clear what kind of "total" you want, and in what
circumstance - if my answers aren't helpful please post a question
with a bit more detail about what you have and what you want.

John W. Vinson[MVP]