how to keep a count of certain entries from other fields

[TracyYu]

I have the following field: Day_1, Day_2, Day_3, ... Day_10 their value can be: X, Y, or Z

Then I have a field: all_X this field is a count of total number of X's entered in the Day_# fields.

Anyone has an idea how to do that? X-)

Thanks in advance.

p.s.
all_X field is locked, so no data can be entered.

 

[PHV]

Something like this ?
=Abs((Day_1=X)+(Day_2=X) (...) +(Day_9=X)+(Day_10=X))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244