BTW, I find it easier to view the data from the table.
Click View, on the top toolbar, and click View as table
when replacing.
Walter Beardwood
Database Administrator
The Exploration Place
----- Original Message -----
From: "Oklahoma Wildlife Federation" <[EMAIL PROTECTED]>
To: "TechRocks Support" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 9:17 AM
Subject: [support] Fw: RE: Counties field
> I can't figure out how to do the replace Command. Also, when I try to
work
> with the zip_ file I downloaded, it won't let me open it because it was
> created in FM 5.5 and I have version 4.1.
>
> Any advice?
> Lance Meek
> Oklahoma Wildlife Federation
> ----- Original Message -----
> From: Bob LeLievre <[EMAIL PROTECTED]>
> To: TechRocks Support <[EMAIL PROTECTED]>
> Sent: Tuesday, May 29, 2001 5:30 PM
> Subject: [support] RE: Counties field
>
>
> > Goto the downloads section of www.lelievre.net and get an updated zip_
> file.
> > This has a fairly complete list of all the zip codes in the US. Each
zip
> > code record also has fields for county, congressional district, time
zone,
> > area code, etc.
> >
> > If you haven't changed your current zip_ file, overwrite the old with
the
> > new one (with ebase closed, of course). Then you could do a REPLACE of
> the
> > county field in the names_ file with the county data from the zips_
file.
> >
> > If you aren't familiar with using the REPLACE command, just ask for more
> > details.
> >
> > ------------------------------------------------------------
> > Bob LeLievre
> > LeLievre Information Services
> > List Management Services for Non-Profits
> > voice: 617-474-9131
> > email: [EMAIL PROTECTED]
> > website: www.lelievre.net
> >
> >
> >
> > -----Original Message-----
> > From: Oklahoma Wildlife Federation [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 29, 2001 5:23 PM
> > To: TechRocks Support
> > Subject: [support] Counties field
> >
> >
> > Ebasers,
> >
> > I need to find all of our members in 22 counties. I have never
added
> > anything to the County field in Ebase. I didn't even realize Ebase had
a
> > spot for them.
> >
> > I would like to be able to do a query in this field to find all our
> members
> > in these counties. Otherwise, I'll have to do each town. Is there a
way
> to
> > do this?
> >
> > Thanks,
> > Lance Meek
> > Oklahoma Wildlife Federation
> >
> >
> >
> > ------------------
> > 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
> > ---------------------------------------------------------------------
> >
> >
> >
> > ------------------
> > 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
> > ---------------------------------------------------------------------
> >
> >
>
>
>
> ------------------
> 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
> ---------------------------------------------------------------------
>
>
------------------
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
---------------------------------------------------------------------
