Counting

[auburnfan]

Have a small problem.
I need to find a way to figure out the number of 1's in a table.
Here is a breakdown of it.
{table.1} has two possible outcomes a 1 and a 0
what I need is if {table.1} has a 1 in it
then I need it to count the number of 1's in the field (there will be many) and give me that total.
The version I have is 9 and it is an ODBC database. Ummm, not sure what other info I could give.
Thanks in advance

 

[lbass]

Place the field in the detail section and right click on it and insert a summary--a sum, not count.

-LB