Results 1 to 2 of 2
  1. #1
    jdftwrth98 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    1

    Access 2010 Macros

    Hi,



    I am new to access 2010 and am drawing a blank on how to rearrange values in a table row

    For example, if i had a database with a table that had say 1000 rows and each row was comprised of columns and the data was entered in the order it appeared in the source, but now i would like to re-sequence data in each row so as the data in the individual columns is in sequence.

    col1 col2 col3 col4 col5

    cat bat rat cow dog

    What i want to do is reorder the data like this

    col1 col2 col3 col4 col5

    bat cat cow dog rat

    How would you write a macro to read every row in the table and re-sequence the data in the columns?

    Thanks,

    JD

  2. #2
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    you don't have to. you know what I would do? export the set to excel, use the transform feature in excel, then put it right back into excel.

    my guess would be, 1-5 minutes, DONE.

    when it comes to data manipulation itself, excel can rock the livin he$$ out of access every single time. access is too bloated with "enhanced features for users" to be truly great at raw data manipulation.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Run Excel Macros in Access
    By jo15765 in forum Programming
    Replies: 8
    Last Post: 10-13-2011, 01:20 PM
  2. Really need help with 2010 Macros
    By Tablerone in forum Programming
    Replies: 2
    Last Post: 10-04-2011, 04:27 PM
  3. Macros in Access
    By King in forum Access
    Replies: 1
    Last Post: 09-22-2011, 05:54 PM
  4. Using Excel macros in Access
    By Lorlai in forum Programming
    Replies: 2
    Last Post: 06-03-2011, 02:01 PM
  5. Access macros
    By mamig in forum Access
    Replies: 2
    Last Post: 01-09-2010, 11:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums