Page 1 of 1

Edit Record Filter

Posted: Wed Apr 14, 2010 8:46 pm
by wms7328
Trying to write a custom report that will give us a listing of new members with pictures using the filter of family tagged or untagged. When selecting the record filter of tagged, I'm selecting "Tagged is not an empty field". However, in using this, I get all the records not just the tagged ones. If I select "Tagged is an empty field", I get no records selected. Not sure what else I would use for this field.

Please any help in using tagging to make this selection would be appreciated.

Re: Edit Record Filter

Posted: Wed Apr 14, 2010 8:49 pm
by Tracy
Tagged is either a Y or an N.

Tagged exactly matches Y will give you all tagged records.

Re: Edit Record Filter

Posted: Thu Apr 15, 2010 10:44 am
by Zorak
Tracy wrote:Tagged is either a Y or an N.
Additionally, [blank] is treated as N. Those who have never been tagged will be tagged = "". If you ever need to report on those who are NOT tagged, choose Tagged does not equal "Y". Otherwise, you would have to define two conditions: tagged is not blank [OR] tagged equals "N".