1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Access 2007 Question - update query

Discussion in 'Microsoft Office' started by Rezzell, May 24, 2010.

  1. Rezzell

    Rezzell Flightless Bird

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

    Db Flightless Bird

    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@discussions.microsoft.com> wrote in message
    news:5CF170BB-BADB-427F-8249-9A90AF4E972B@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@bob.com and strip the
    > @bob.com off to make it just joe. Any thoughts?
     

Share This Page