Prev: Just want one window to open
Next: lost outlook 2007 disks and home and student 2007
From: Rezzell on 24 May 2010 11:34
I have an access database that has a bunch of email addresses in it. I want
to strip it down to just the username. What criteria will I use in my update
query to get the desired results. I want to take joe(a)bob.com and strip the
@bob.com off to make it just joe. Any thoughts?
From: Db on 24 May 2010 11:58
what I would simply do but
may be tricky for you is

take the data from that table
and paste it into excel.

once in excel you can use
formulas to strip down the
data in the cell.

then you can take the data
from the excel table/spread-
sheet back into that access
table.

or link access to that excel
table.

if you have never used excel
to modify data in access tables,

then it would be something
worthwhile to learn because
it is highly handy.

also be sure to make a couple
of backups/copes of your
original access database
before

--
--
db·´¯`·...¸><)))º>

DatabaseBen, Retired Professional

~~~~~~~~~~~~~~~
This NNTP newsgroup is evolving to:

http://answers.microsoft.com/en-us/default.aspx


"Rezzell" <Rezzell(a)discussions.microsoft.com> wrote in message
news:5CF170BB-BADB-427F-8249-9A90AF4E972B(a)microsoft.com...
> I have an access database that has a bunch of email addresses in it. I
> want
> to strip it down to just the username. What criteria will I use in my
> update
> query to get the desired results. I want to take joe(a)bob.com and strip the
> @bob.com off to make it just joe. Any thoughts?

 | 
Pages: 1
Prev: Just want one window to open
Next: lost outlook 2007 disks and home and student 2007