--------------------------------------------
ebase -Free relationship management software for nonprofits
http://www.ebase.org
--------------------------------------------
Clif Graves, Programmer
TechRocks
RR4 Box 2000
Winthrop ME 04364
Email: [EMAIL PROTECTED]
eFax: 425.790.2058 Web: http://www.techrocks.org
--------------------------------------------
"If you experience any problems with this site it is normal" disclaimer
found on FM Database Solutions Website
> -----Original Message-----
> From: Clif Graves TechRocks [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 05, 2000 4:47 PM
> To: Rock Creek Alliance
> Subject: RE: [SUPPORT] Using OMIT with Query
>
>
> Teresa, I am not sure if there is any inconsistency re: this
> between v1.0 and 1.02 but here is an answer. The email field is
> not a numerical field and so is not a good choice for Finds using
> Less than < or greater than >, after all is
> "[EMAIL PROTECTED]" greater or less than "[EMAIL PROTECTED]"?
>
> The better Finds for email fields are exact match or * for any value.
>
> So to find all the folks with email addresses who live in your
> state, go the data entry screen, click on the find button and put
> "ID" in the State field and "*" (not quotes) in the email field.
> To Omit the same folks put a check in the omit box.
>
> Hopefully that will put you back on the road to creatively
> leaving folks out ;-)
>
> Clif
>
> --------------------------------------------
> ebase -Free relationship management software for nonprofits
> http://www.ebase.org
> --------------------------------------------
> Clif Graves, Programmer
> TechRocks
> RR4 Box 2000
> Winthrop ME 04364
> Email: [EMAIL PROTECTED]
> eFax: 425.790.2058 Web: http://www.techrocks.org
> --------------------------------------------
> "If you experience any problems with this site it is normal"
> disclaimer found on FM Database Solutions Website
>
> > -----Original Message-----
> > From: Rock Creek Alliance [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, December 05, 2000 12:42 PM
> > To: ebase
> > Subject: [SUPPORT] Using OMIT with Query
> >
> >
> > Since we are one the subject....
> > Every since I updated to v1.2 my omit button doesn't work when I
> > am doing a
> > search in Query. For example, if I search using the city line for every
> > member who lives in Timbuktu, modify, add a search, check omit, < in the
> > email field, I should end up with the Timbuktu people who have email
> > address's. Instead I get the full count.
> >
> > Or if I query email =>, add an additional search for Timbuktu I
> still get
> > everyone in Timbuktu with email address's or not.
> >
> > I can't narrow searches without the omit button and it gets
> > frustrating. Any
> > suggestions?
> > Rock Creek Alliance
> > Teresa M. Sanders
> > 1319 N. Division
> > Sandpoint, ID 83864
> > 208.265.8272
> > [EMAIL PROTECTED]
> >
> >
