Calculated field help

[eds]

I have a small database containing club membership data. The data is mostly in 1 table. Each club member must attend 5 meetings per year. There is 1 meeting per month. The table data is represented as 12 text fields (jan thru dec). If a member attends a meeting the user places an X in the appropriate month field. I need to produce a report that contains first name, last name, and number of meetings attended. Any help would be greatly appreciated.

[June7]

You need to add up the Xs. Use an expression in a field of the query, like:

This, if really is a text datatype
IIf([Jan]="X",1,0) + IIF([Feb]="X",1,0) + ...

Or

For Yes/No datatype
Abs([Jan]+[Feb]+[Mar]...)

[eds]

You need to add up the Xs. Use an expression in a field of the query, like:

This, if really is a text datatype
IIf([Jan]="X",1,0) + IIF([Feb]="X",1,0) + ...

Or

For Yes/No datatype
Abs([Jan]+[Feb]+[Mar]...)

IIF statement worked perfectly. Thanks for your help !