Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Concatenate Function

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

  1. Bob

    Bob
    Expand Collapse
    Guest

    I have probably a relatively easy question that I just can't figure out the
    answer to. I have a field of data that reads like this

    01129208

    What I would like to do is add a zero on the end to have it read 011292080

    I know in Excel there is a concatenate function I can do this with, but does
    something similiar exist in MS Access?
     
  2. Loading...


  3. Bob

    Bob
    Expand Collapse
    Guest

    "Bob" wrote:

    > I have probably a relatively easy question that I just can't figure out the
    > answer to. I have a field of data that reads like this
    >
    > 01129208
    >
    > What I would like to do is add a zero on the end to have it read 011292080
    >
    > I know in Excel there is a concatenate function I can do this with, but does
    > something similiar exist in MS Access?



    Actually I figured it out by typing the 01129208 + "0"...I knew it was in my
    head somewhere
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    I'd recommend using & for concatenation, to ensure that Access doesn't get
    confused and treat it as adding zero to the number.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Bob" <Bob@discussions.microsoft.com> wrote in message
    news:6C1B4666-A795-4C00-9280-0BE2E072099C@microsoft.com...
    >
    >
    > "Bob" wrote:
    >
    > > I have probably a relatively easy question that I just can't figure out

    the
    > > answer to. I have a field of data that reads like this
    > >
    > > 01129208
    > >
    > > What I would like to do is add a zero on the end to have it read

    011292080
    > >
    > > I know in Excel there is a concatenate function I can do this with, but

    does
    > > something similiar exist in MS Access?

    >
    >
    > Actually I figured it out by typing the 01129208 + "0"...I knew it was in

    my
    > head somewhere
     

Share This Page