Welcome to SPN

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

Sign Up Now!

merge columns in a table

Discussion in 'Information Technology' started by Matt, Sheffield, UK, Jul 28, 2006.

  1. Matt, Sheffield, UK

    Matt, Sheffield, UK
    Expand Collapse
    Guest

    I have 4 fields, columns in a table that I need to merge, i need to keep all
    the data in each row in each field, but want them all in one field so i can
    delete the other 3.

    any ideas guys
    Matt
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Why? Are you sure you'll never need them unmerged again? What do the 3
    existing fields represent? Does merging them into a single column represent
    a violation of database normalization principles?

    My advice would be to eliminate the 4th field from your table. Create a
    query that uses & merges the 3 existing fields into a computed field, and
    use the query wherever you would otherwise have used the table.

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


    <Matt>; <Sheffield>; "UK" <MattSheffieldUK@discussions.microsoft.com> wrote
    in message news:10D3225A-F482-4C08-8EB1-360F09AA4397@microsoft.com...
    > I have 4 fields, columns in a table that I need to merge, i need to keep

    all
    > the data in each row in each field, but want them all in one field so i

    can
    > delete the other 3.
    >
    > any ideas guys
    > Matt
     

Share This Page