A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 Question - update query



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2010, 04:34 PM posted to microsoft.public.office.misc
Rezzell
external usenet poster
 
Posts: 1
Default Access 2007 Question - update query

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 and strip the
@bob.com off to make it just joe. Any thoughts?
  #2  
Old May 24th, 2010, 04:58 PM posted to microsoft.public.office.misc
Db
external usenet poster
 
Posts: 2
Default Access 2007 Question - update query

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" wrote in message
...
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 and strip the
@bob.com off to make it just joe. Any thoughts?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.