Welcome to SPN

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

Sign Up Now!

Carriage Return

Discussion in 'Information Technology' started by PR, Nov 7, 2005.

  1. PR

    PR
    Expand Collapse
    Guest

    I have some data in multi fields and I am try to enter the data into one
    field, I have done the query to enable this, but I want to put a carriage
    return between the fields as I append the data to the new field.

    Can anyone help.

    PR
     
  2. Loading...

    Similar Threads Forum Date
    Link Between Antidepressants and Miscarriage Parenting Jun 1, 2010
    Sikh News Lahore - Nankana Sahib Dual Carriageway in pipeline Breaking News Jan 4, 2005
    Sikh News Ontario Police Review Arrest Of Sikh Man Whose Turban Wasn't Returned - CTV News Breaking News Jul 16, 2016
    Movies Ashdoc's short movie review---Tanu weds Manu returns Theatre, Movies & Cinema Jun 6, 2015
    Zoroastrianism Parsis pray for return of the scavenger bird Interfaith Dialogues Aug 28, 2013

  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    Chr$(13) & Chr$(10). For example ...

    UPDATE tblTest SET tblTest.TestMemo = [TestText] & Chr$(13) & Chr$(10) &
    [PathName]
    WHERE (((tblTest.TestText) Is Not Null) AND ((tblTest.PathName) Is Not
    Null));

    --
    Brendan Reynolds


    "PR" <paul.raeburn@ntlworld.com> wrote in message
    news:eDP6$Rv4FHA.268@TK2MSFTNGP10.phx.gbl...
    >I have some data in multi fields and I am try to enter the data into one
    >field, I have done the query to enable this, but I want to put a carriage
    >return between the fields as I append the data to the new field.
    >
    > Can anyone help.
    >
    > PR
    >
     
  4. Al Camp

    Al Camp
    Expand Collapse
    Guest

    PR,
    [Field1] & vbCrLf & [Field2] & vbCrLf... etc...
    should concatenate the data the way you want.
    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "PR" <paul.raeburn@ntlworld.com> wrote in message
    news:eDP6$Rv4FHA.268@TK2MSFTNGP10.phx.gbl...
    >I have some data in multi fields and I am try to enter the data into one
    >field, I have done the query to enable this, but I want to put a carriage
    >return between the fields as I append the data to the new field.
    >
    > Can anyone help.
    >
    > PR
    >
     
  5. Duane Hookom

    Duane Hookom
    Expand Collapse
    Guest

    You can use something like:
    [FieldA] & Chr(13) & Chr(10) & [FieldB]

    --
    Duane Hookom
    MS Access MVP


    "PR" <paul.raeburn@ntlworld.com> wrote in message
    news:eDP6$Rv4FHA.268@TK2MSFTNGP10.phx.gbl...
    >I have some data in multi fields and I am try to enter the data into one
    >field, I have done the query to enable this, but I want to put a carriage
    >return between the fields as I append the data to the new field.
    >
    > Can anyone help.
    >
    > PR
    >
     
  6. Duane Hookom

    Duane Hookom
    Expand Collapse
    Guest

    vbCrLf works great in code/module but will fail in query expressions and
    control sources.

    --
    Duane Hookom
    MS Access MVP


    "Al Camp" <anon@anon.net> wrote in message
    news:un3UyWv4FHA.1124@tk2msftngp13.phx.gbl...
    > PR,
    > [Field1] & vbCrLf & [Field2] & vbCrLf... etc...
    > should concatenate the data the way you want.
    > --
    > hth
    > Al Camp
    > Candia Computer Consulting - Candia NH
    > http://home.comcast.net/~cccsolutions
    >
    > "PR" <paul.raeburn@ntlworld.com> wrote in message
    > news:eDP6$Rv4FHA.268@TK2MSFTNGP10.phx.gbl...
    >>I have some data in multi fields and I am try to enter the data into one
    >>field, I have done the query to enable this, but I want to put a carriage
    >>return between the fields as I append the data to the new field.
    >>
    >> Can anyone help.
    >>
    >> PR
    >>

    >
    >
     
  7. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Thanks for that correction...
    Al Camp

    "Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
    news:ejIXc2w4FHA.472@TK2MSFTNGP15.phx.gbl...
    > vbCrLf works great in code/module but will fail in query expressions and
    > control sources.
    >
    > --
    > Duane Hookom
    > MS Access MVP
    >
    >
    > "Al Camp" <anon@anon.net> wrote in message
    > news:un3UyWv4FHA.1124@tk2msftngp13.phx.gbl...
    >> PR,
    >> [Field1] & vbCrLf & [Field2] & vbCrLf... etc...
    >> should concatenate the data the way you want.
    >> --
    >> hth
    >> Al Camp
    >> Candia Computer Consulting - Candia NH
    >> http://home.comcast.net/~cccsolutions
    >>
    >> "PR" <paul.raeburn@ntlworld.com> wrote in message
    >> news:eDP6$Rv4FHA.268@TK2MSFTNGP10.phx.gbl...
    >>>I have some data in multi fields and I am try to enter the data into one
    >>>field, I have done the query to enable this, but I want to put a carriage
    >>>return between the fields as I append the data to the new field.
    >>>
    >>> Can anyone help.
    >>>
    >>> PR
    >>>

    >>
    >>

    >
    >
     

Share This Page