generating scores based on number of tick boxes

[sk88]

I am wondering if it is possible to calculate scores automatically based on the number of tick boxes the users have selected? If yes, how do I go about doing this feature?

Thanks

[June7]

Are the 'tick boxes' you want to count the yes/no fields of a single record? If so, this will not be easy. How many yes/no fields?

[sk88]

Are the 'tick boxes' you want to count the yes/no fields of a single record? If so, this will not be easy. How many yes/no fields?

you are right.. they are tick boxes.. I have like 5 or 6 tick boxes. I actually need to know if 2 or more tick boxes selected, it should give me an answer. :s Is it something possible?

[June7]

Okay, not so bad after all, I think. Create a field in query with expression. Try something like: IIf(Abs([f1]+[f2]+[f3]+[f4]+[f5])>2,1,Null)
Use your field names in place of f1, f2, etc. You can have the IIf return whatever values you want - I show 1 or Null will return.

[bcmarshall]

Just had to pipe up here. Great solution with the Abs() function! Hadn't thought of that one but it's in my bag of tricks now. To the original poster, this should work wonderfully, and you can set whatever score you want as your value.

Super slick!

[June7]

Actually, IIf([f1]+[f2]+[f3]+[f4]+[f5])<-2,1,Null) probably would work just as well but thought OP would be more comfortable with the positive number criteria.