>I am looking for a shortcut way to do this.
>Thanks in advance and then some.

Just make sure there is zero "N"s, instead of a variable amount of "Y"s, BTW, why aren't you using logical fields for this?