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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|