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