New user question

[LarryH]

I maintain a club database and I'm trying to automate attendance taking. Each member record has a month field and I enter either an "o" for officers, "m" for members and "v" vor visitors in the month field if they have attended the monthly meeting. How do I count the "o" + "m" + "v" and end up with a total attendance for the month. Is this a calculation or a scripting function.

[Ocean West]

You create 3 fields for the values

cOfficers:

month = "o"

cMembers:

month = "m"

cVisitors:

month = "v"

This will result in a boolian value (1 or 0) Then you can sum the values

using the summary field (total of)

total of cOfficers etc.

then you could create a grand total

by adding up all three fields