Welcome to SPN

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

Sign Up Now!

Strings

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

Tags:
  1. Boots

    Boots
    Expand Collapse
    Guest

    Hi, On a form I have 3 boxes which are used to input different parts of a
    course name. The 3 boxes keep the course name uniformed. How can I bring
    the three fields together and produce a string which contains the entire name
    and have this sent to my table. The attempts i have made have all failed so
    far

    Thanks
     
  2. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    If you got this fields seperated now, you can always join them using a query

    Select [Field1] & " " & [Field2] & " " & [Field3] As FullField From TableName

    Any way, to join the three fields you can use the above example
    [Field1] & " " & [Field2] & " " & [Field3]

    --
    Good Luck
    BS"D


    "Boots" wrote:

    > Hi, On a form I have 3 boxes which are used to input different parts of a
    > course name. The 3 boxes keep the course name uniformed. How can I bring
    > the three fields together and produce a string which contains the entire name
    > and have this sent to my table. The attempts i have made have all failed so
    > far
    >
    > Thanks
     

Share This Page