Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy one data to multiple columns (2003)

    Is any shortcut to paste one data to multiple columns in table? I highlight the columns that I want to paste, and then click "CTRL + V". It only paste to one columns even I select ten columns.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy one data to multiple columns (2003)

    Access is not a spreadsheet, so you can't easily do what you describe. Furthermore, it sounds like the design of the table is not normalized or you would not be attempting to multiple columns of data. Could you explain in more detail what you are trying to accomplish?
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy one data to multiple columns (2003)

    Hi Charlotte,

    I am import a text format file to access table, then I need add one field in the table. However there are the data of this field are the same, that's why I am tring to find a shortcut to paste the same data to whole column instead of paste one by one.

    Any suggestions, I really need add the data to this field in order for me to run the report. It will be really help if you can help me with some shortcut because there are around 75,000 columns in this field.

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy one data to multiple columns (2003)

    75,0000 columns in a field? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>.

    If you want to set the values of one field to the values of another field, you can use an update query. Let's say that you want to set the values of FieldA to those of FieldB.
    - Create a new query based on the table.
    - Add FieldA to the query grid.
    - Select Query | Update Query. This adds a row labeled 'Update to'.
    - Enter [FieldB] in the 'Update to' row under FieldA.
    - Repeat for other fields if necessary
    - Select Query | Run to execute the query.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy one data to multiple columns (2003)

    Hi Hans,

    Thank you for help.
    But I need add new values to a new field, the values are not come from any exit field.

    Regards

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy one data to multiple columns (2003)

    You can also enter a constant value in the 'Update to' row.

    If the values don't come from another field, and aren't constant either, you'll have to explain what exactly you want.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •