I'm getting ready to do a big mailing and need to look up folks in our database that have a full address. Many only have partial. How do I do a query to find only addresses that have all fields? How do I do it for international as well? I've read through the handbook, and it is pretty loose guidleines for something like this. We use filemaker 5.0 if that makes a difference.
The general wild card character is
*. In FIND mode, it means "anything at all in this field".
So to search for addresses with data in all fields (presumably
address/delivery, city, state, and zip) put an asterisk in all those
fields. This is in addition to any other search criteria you have,
such as contact flags or the like.
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
